Enumerating mysql tables starting with a specific letter

Question

How to list all tables in MYSQL database starting with "T"?

Answer 1

Assuming MySQL 5.0:

SHOW TABLES LIKE 'T%' 

Here is the documentation

Answer 2

The true ANSI way:

 SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'T%' 

Does not imply the presence or behavior of a USE function. This should work in every DBMS supporting ANSI INFORMATION_SCHEMA views, which of course contain MySQL.

Answer 3

 SHOW TABLES LIKE 'T%'; 

Answer 4

 show tables from db_name like 't%' 

Answer 5

I use this internal mysql shell program:

use information_schema; select table_name from the tables where table_name, for example 't%';