Mega Code Archive

 

Categories / MySQL / Command Mysql

 

SHOW TABLES with LIKE clause

mysql> mysql> SHOW TABLES FROM mysql LIKE 'help%'; +-------------------------+ | Tables_in_mysql (help%) | +-------------------------+ | help_category           | | help_keyword            | | help_relation           | | help_topic              | +-------------------------+ 4 rows in set (0.00 sec)