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 vote385 views1 answer
Oracle simple quote
SQL
1 vote299 views1 answer
Mysql remove last empty newline
SQL
0 vote344 views1 answer
Create-table-with-index-organization
SQL
7 votes293 views1 answer
Append column sql
SQL
0 vote301 views1 answer
Mysql date minus 1 day
SQL
0 vote290 views1 answer
Changer un mot de passe mysql
SQL
0 vote270 views1 answer
Big query add table rows to another table
SQL
2 votes296 views1 answer
Select * from table where name like
SQL
0 vote316 views1 answer
Sql on-premises
SQL
0 vote302 views1 answer
Mysql count grouped rows
SQL