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

5 votes169 views1 answer
Sql asynchronous stored procedure call
SQL
14 votes188 views2 answers
Oracle export trigger ddl
SQL
1 vote187 views1 answer
Postgresql contains
SQL
4 votes183 views1 answer
Wilayah indonesia database
SQL
12 votes199 views1 answer
Run mysql instance in docker
SQL
0 vote185 views2 answers
How covert into int in maria db
SQL
0 vote169 views1 answer
The local psql command could not be located
SQL
1 vote205 views2 answers
Remove space in mysql
SQL
0 vote193 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote129 views1 answer
Ms sql print more than 1 variable
SQL