setting pager to 'less' for mysql

Ever wanted to have 'less' functionality when doing mysql queries?

mysql> \P less -S
PAGER set to 'less -S'

So when you do a 'select *', it will automatically output it to less :)