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 vote138 views1 answer
Mysql isshow
SQL
0 vote142 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote141 views1 answer
Changer un mot de passe mysql
SQL
0 vote139 views1 answer
Postrgres trunc
SQL
0 vote168 views1 answer
Sql server rtrim everything after character
SQL
1 vote120 views1 answer
Strict in postgres SQL
SQL
1 vote95 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote167 views1 answer
Sql server insert inner join
SQL
0 vote159 views3 answers
Sql query checker
SQL
0 vote163 views1 answer
Default column value in sql same as another column laravel
SQL