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 vote244 views1 answer
Sql alchemy with azuresql server
SQL
17 votes243 views4 answers
Mysql remove ubuntu
SQL
31 votes245 views2 answers
Grant all priviledges to mysql user
SQL
0 vote222 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote232 views1 answer
Mysql procedure between two tables
SQL
12 votes263 views1 answer
Run mysql instance in docker
SQL
0 vote227 views1 answer
How to print out column name differently in mysql
SQL
0 vote279 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote240 views2 answers
Update query with between in mysql
SQL
-1 vote218 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL