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 vote203 views1 answer
Dasebase_url-postgres for windows
SQL
2 votes210 views1 answer
How to check grants on a package in oracle
SQL
11 votes228 views4 answers
Update row in mysql
SQL
0 vote221 views1 answer
Oracle procedure teamplate
SQL
0 vote202 views1 answer
Sql select all tables from database change url
SQL
0 vote199 views1 answer
Change default schema sql server
SQL
-1 vote181 views1 answer
Oracle db list usernames
SQL
0 vote186 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote172 views1 answer
Sql select rows with simlar names
SQL
0 vote193 views1 answer
Mysql create table columns with spaces
SQL