Need to explore results in the MySQL REPL? The
pager command can help.
Let’s set our pager of choice (we’ll use Less):
mysql> pager less PAGER set to 'less'
Then, execute the query:
mysql> select * from users;
The result will be loaded in the Less pager. From here, we can navigate or search through the results.
Leave the custom pager with
mysql> \n PAGER set to stdout