It sounds like you're describing the command line interface within DOS or a shell.
There are other ways of connecting with MySQL that give you much more control over the results of queries - being able to view them in spreadsheet like tables, with the ability to sort results and also export them easily to a spreadsheet program like Excel.
For free tools:
If you're on a Mac, we recommend Sequel Pro -
https://www.sequelpro.com/
If on Windows, try Heidi SQL -
https://www.heidisql.com/download.php
Or for a cross platform (Windows, Mac, Linux) paid tool, try Navicat (they also offer a free trial) -
https://www.navicat.com