If you are selecting a single row with a large number of columns in MySQL (a common use case for me at least), here’s a handy tip: you can display the column data vertically instead of horizontally by ending the query with \G instead of a semi-colon.
For example:
SELECT * FROM wp_users WHERE ID = 1\G *************************** 1. row *************************** ID: 1 user_login: paul user_nicename: paul user_email: paul@phpdeveloper.org.uk user_url: user_registered: 2010-07-04 14:04:31 user_activation_key: user_status: 0 display_name: Paul 1 row in set (0.00 sec)
You can do the same if more than one row is returned, and each one will be separated by asterisks.