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 vote169 views1 answer
How to show current database in mysql
SQL
0 vote106 views5 answers
Sql table intermédiaire
SQL
-1 vote107 views1 answer
How to format tables in sqlplus
SQL
0 vote114 views1 answer
Implizite joins sql
SQL
0 vote118 views1 answer
Fast sql column count
SQL
0 vote137 views1 answer
Except in sql
SQL
1 vote110 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote138 views1 answer
Sql get table last modified time
SQL
0 vote118 views1 answer
Psotgres multiple values
SQL
0 vote117 views1 answer
Psql store procedure-return multiple table values
SQL