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

1 vote332 views1 answer
Pv mysql import
SQL
0 vote358 views1 answer
Oracle locked objects
SQL
0 vote328 views1 answer
Get last updated row sql server
SQL
1 vote293 views1 answer
Strict in postgres SQL
SQL
13 votes353 views2 answers
Sql join 3 tables
SQL
0 vote421 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
24 votes360 views5 answers
Import dump mysql
SQL
5 votes341 views2 answers
Oracle list columns schema
SQL
1 vote343 views2 answers
Postgres copy table from one schema to another
SQL
1 vote320 views2 answers
T-sql random number for each row
SQL