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 vote118 views1 answer
Postgres : ERROR: division by zero
SQL
4 votes105 views4 answers
Print pl sql
SQL
1 vote107 views1 answer
Foreign key constraint in ms sql
SQL
0 vote119 views1 answer
Sql anywhere create procedure
SQL
0 vote122 views2 answers
How to start postgresql laravel
SQL
0 vote74 views1 answer
Mysql offset from bottom
SQL
103 votes196 views1 answer
Like sql
SQL
1 vote113 views1 answer
Check message id sql server
SQL
1 vote144 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
1 vote119 views1 answer
Input in mysql
SQL