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 votes303 views1 answer
Removing view
SQL
0 vote314 views3 answers
How to increase size of column in sql
SQL
0 vote239 views1 answer
Oracle function select into
SQL
-1 vote259 views1 answer
Mysql if example
SQL
0 vote283 views1 answer
Pl/sql loop example
SQL
0 vote268 views1 answer
Mysql date + 1 day
SQL
0 vote332 views1 answer
Yesql
SQL
0 vote289 views1 answer
Heidisql check how much space a row
SQL
0 vote275 views2 answers
Sql query unique
SQL
1 vote290 views2 answers
Mysql: command not found
SQL