Mysql select tables with name like

Select tables with name like mysql

SELECT table_name
FROM information_schema.tables

Source: stackoverflow.com

Mysql select tables with name like

select table_schema as database_name,
    table_name
from information_schema.tables
where table_type = 'BASE TABLE'
    and table_name like 'cu%'
order by table_schema,
     table_name;

Source: dataedo.com

Similar codes

14 votes167 views6 answers
Finding duplicate rows mysql
SQL
29 votes134 views5 answers
Mysql show table structure
SQL
-1 vote154 views1 answer
MYSQL stored procedure select from
SQL
11 votes147 views1 answer
Creating tables in sql with python
SQL
0 vote133 views1 answer
Automate mysql cli query
SQL
0 vote134 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
1 vote127 views3 answers
How to filter repeated same result using sql query
SQL
0 vote144 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote136 views1 answer
Groupby error in mysql
SQL
0 vote138 views1 answer
Mysql select distinct date from timestamp
SQL