With mysql show tables; can I sort by table name while ignoring case?

Question

Is there a way to sort the list of tables returned by mysql's 'show tables' command?

mysql> show tables;

I'd like to sort alphabetically by the table name.

EDIT:

As pointed out by one of the answers, they are already in alphabetical order. However, A != a. Is there a way to ignore case in the sort?

Answer 1

Query information_schema and replace database_name with the name of the database you want to return the tables from

SELECT table_name, engine
FROM information_schema.tables    
WHERE table_type = 'BASE TABLE' AND table_schema='database_name'  
ORDER BY table_name ASC;