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

60 votes527 views6 answers
Add column in sql
SQL
2 votes362 views1 answer
How to check if a row is null in sql
SQL
0 vote328 views1 answer
Mysql update from select on same table
SQL
1 vote306 views1 answer
Oracle create program if no exists
SQL
0 vote347 views1 answer
Table structure in sql
SQL
10 votes338 views2 answers
Tsql merge example
SQL
-2 votes313 views1 answer
Use of where in left join in mysql
SQL
5 votes353 views2 answers
Functions
SQL
0 vote337 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote332 views1 answer
Consulta alias con inner join
SQL