Posted By

ktrout on 01/03/16

Tagged

mysql
search

Versions (?)

Last Edited at 01/03/16 01:32pm

Statistics

Viewed 885 times

Favorited by 0 user(s)

Related snippets

mysql tablename search information schema

/ Published in: SQL

search for tables in mysql catalog ( information_schema )

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT table_catalog, table_schema, TABLE_NAME, table_type, engine
FROM information_schema.tables
WHERE TABLE_NAME LIKE '%digits%'
;
 
/*
+---------------+--------------+------------+------------+--------+
| table_catalog | table_schema | table_name | table_type | engine |
+---------------+--------------+------------+------------+--------+
| def           | test         | digits_v   | VIEW       | NULL   |
+---------------+--------------+------------+------------+--------+
*/