Formatting mysql output

MySQL has a nice output preprocessor. You can set it using the PAGER command, and reset it with NOPAGER.
The syntax simply points to a command in PATH or to a custom script.

sql> PAGER command arg1 arg2 ..

ex1. To show only the delay of a master-slave replica, you can

sql> PAGER grep -i ‘second’
sql> SHOW SLAVE STATUS
sql> NOPAGER

ex2. show processes

sql> PAGER egrep -v Sleep
sql> SHOW PROCESSLIST
sql> NOPAGER

Suggest your own!