Format query output at mysql prompt?

I'm just wondering if there's a way to print out the results from a query conducted at the mysql prompt so that it's a little easier to read.

Rather than:

field a | field b | field c
+---------------+-------------+-------------+
| 100 | abcedef | ghijklmnop

is there a way to print to screen so that it looks like this:

field a | 100
field b | abcedef
field c | ghijklmnop

Not sure it's any easier to read but try terminating with a \G instead of a ; for that type of display

Perfect! Thanks!

MySQL query ouput can be formatted in better way using \P less -S option as below:

mysql> \P less -S
mysql> <SELECT QUERY>

Is there a way to format MySQL query output that is printed to a browser window? Like an HTML and JavaScript website that uses php to make MySQL queries. I would like to format my output into easily readable HTML tables and use some CSS.

Thanks in advance for any suggestions!