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

3 votes295 views2 answers
Sql paging query
SQL
0 vote286 views1 answer
Postgresql certain first 4 characters in string
SQL
1 vote291 views1 answer
Sql server 2012 query history
SQL
0 vote282 views1 answer
Select all tables linked server sql
SQL
1 vote276 views2 answers
Postgresql list columns
SQL
5 votes286 views2 answers
Add column postgres with default value
SQL
0 vote290 views1 answer
Drush run sql select
SQL
1 vote303 views1 answer
Where not in array sql
SQL
16 votes343 views3 answers
Get count of duplicate records
SQL
7 votes306 views2 answers
Where keyword sql
SQL