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 vote151 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote187 views1 answer
How to run mysql on terminal mac
SQL
0 vote162 views1 answer
Mysqldump ignore table
SQL
0 vote169 views1 answer
Sql server select ignore dupplicates
SQL
0 vote180 views1 answer
Sql string contains case sensitive
SQL
11 votes202 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote158 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
2 votes165 views2 answers
Mysql user access to database
SQL
0 vote163 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote185 views1 answer
Query builder doctrien return sql
SQL