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

2 votes182 views1 answer
Oracle list duplicates
SQL
0 vote172 views1 answer
Initcap in sql
SQL
0 vote497 views1 answer
Sql field equals multiple values
SQL
0 vote188 views1 answer
How to to get time in sql
SQL
0 vote171 views1 answer
Oracle db get table sizes
SQL
0 vote180 views1 answer
Sql server isnull function nor working count
SQL
2 votes210 views2 answers
How to run postgresql in linux
SQL
0 vote195 views2 answers
Cambiar nombre tabla mysql
SQL
1 vote171 views3 answers
Mysql Server Start
SQL
3 votes175 views1 answer
Make a field auto_increment mysql
SQL