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

0 vote332 views1 answer
Sql dmv to capture updates
SQL
0 vote348 views1 answer
How to see password mysql vestacp
SQL
5 votes303 views2 answers
Mysql where in array
SQL
0 vote341 views1 answer
Call scalar valued function sql
SQL
3 votes358 views2 answers
Sql add year to date
SQL
2 votes403 views1 answer
Tcl in sql
SQL
0 vote350 views1 answer
Mysql trigger to delete old data
SQL
0 vote336 views1 answer
How to use group_concat in sql server
SQL
0 vote317 views1 answer
Check for directory in bash
SQL
3 votes341 views1 answer
How to find names includes in sql
SQL