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 vote325 views1 answer
Synapse sql table set pk
SQL
0 vote292 views1 answer
Sql requete number pair
SQL
10 votes308 views1 answer
All_dependencies
SQL
0 vote313 views1 answer
Mysql trim characters
SQL
7 votes326 views2 answers
Mysql db size
SQL
4 votes301 views2 answers
How to delete row in sql
SQL
39 votes402 views4 answers
Select duplicates in sql
SQL
0 vote340 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote310 views1 answer
Database springboot
SQL
6 votes351 views2 answers
Mysql execute file
SQL