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 vote382 views1 answer
Oracle nvl2
SQL
21 votes385 views3 answers
Sql server search column name in all tables
SQL
0 vote358 views1 answer
Mysql search multiple tables
SQL
0 vote345 views1 answer
Groupby error in mysql
SQL
0 vote367 views1 answer
How to delete python anywhere mysql database
SQL
0 vote423 views1 answer
Sql query for login with email or username
SQL
2 votes358 views1 answer
Oracle list grants on package
SQL
1 vote575 views2 answers
Sql unique rows
SQL
0 vote339 views1 answer
Oracle list chain steps
SQL
0 vote305 views1 answer
Mysql insert with foreign key
SQL