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 vote144 views1 answer
Create table using the clause with as
SQL
11 votes189 views2 answers
You are using safe update mode
SQL
0 vote145 views1 answer
Drush run sql select
SQL
0 vote149 views1 answer
SQLServerException.makeFromDatabaseError
SQL
5 votes132 views4 answers
Rollback to in sql
SQL
1 vote147 views1 answer
Sql find column name like
SQL
13 votes140 views1 answer
Select count of distinct values sql
SQL
0 vote142 views3 answers
Fetlife
SQL
2 votes127 views2 answers
Oracle create table if not exists
SQL
1 vote137 views1 answer
Check message id sql server
SQL