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 vote180 views1 answer
Io
SQL
3 votes170 views2 answers
Oracle sql drop sequence
SQL
0 vote172 views1 answer
Can we rollback in sql
SQL
1 vote360 views1 answer
Postgres upgrade to superuser
SQL
7 votes182 views2 answers
Sql server drop temp table if exists
SQL
0 vote166 views1 answer
Parsing float to int in mysql
SQL
0 vote167 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote186 views2 answers
Mysql trim spaces
SQL
1 vote165 views1 answer
Postgres killing connections on db
SQL
0 vote169 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL