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

8 votes187 views1 answer
Sql remove leading spaces
SQL
0 vote190 views1 answer
Select place default lat long
SQL
34 votes234 views6 answers
Alter table add foreign key mysql
SQL
1 vote242 views1 answer
Sql query row number group by
SQL
19 votes198 views6 answers
Mysql if null
SQL
0 vote235 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote192 views1 answer
Python mysql query to dataframe
SQL
0 vote177 views1 answer
Sql compound operators
SQL
14 votes181 views3 answers
Delete all records from table except sql
SQL
4 votes183 views2 answers
How to count items with same name in sql
SQL