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

2 votes266 views3 answers
3 days back in sql server
SQL
0 vote267 views4 answers
Best data type to represent money in mysql
SQL
0 vote284 views1 answer
Mysql query to select the highest value
SQL
0 vote265 views1 answer
Python mysql executemany
SQL
-1 vote280 views1 answer
Window functions in sql
SQL
10 votes256 views3 answers
Sql limit results
SQL
103 votes441 views2 answers
Sql server LIKE '%%'
SQL
1 vote234 views1 answer
Enable mysql slow query log
SQL
0 vote274 views1 answer
Sql count more than 1
SQL
0 vote282 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL