listing mysql tables starting with a particular letter

Question

hi, I'm new for Mysql how to list all tables in MYSQL DB starting with "T" Tx in adv

Answer 1

show tables from db_name like 't%'

Answer 2

Assuming MySQL 5.0:

SHOW TABLES LIKE 'T%'

Here's the documentation

Answer 3

SHOW TABLES LIKE 'T%';

Answer 4

I use this inside mysql shell program:

use information_schema; select table_name from tables where table_name like 't%';

Answer 5

The true ANSI way:

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

Doesn't assume the presence or behaviour of the USE function. This should work in every DBMS supporting the ANSI INFORMATION_SCHEMA views, which definitely includes MySQL.