Mega Code Archive

 

Categories / MySQL / Command Mysql

 

SHOW DATABASES and SHOW TABLES can each take a LIKE pattern clause

SHOW DATABASES LIKE 'm%'; SHOW TABLES FROM world LIKE '%tr%';