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

1 vote264 views1 answer
Mysql select if empty result
SQL
0 vote219 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
2 votes237 views1 answer
Convert series number to date in sql
SQL
0 vote246 views1 answer
Data types mysql vs postgresql
SQL
0 vote258 views1 answer
Sqlplus change user
SQL
1 vote195 views1 answer
Convert money to varchar sql server
SQL
13 votes247 views2 answers
Check if value is null mysql
SQL
3 votes250 views3 answers
Concatenation in sql
SQL
1 vote268 views1 answer
Where to locate set password for mysql
SQL
3 votes291 views5 answers
No module named 'MySQLdb'
SQL