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 vote234 views1 answer
Import mysql'
SQL
1 vote213 views1 answer
Change table to innodb mysql
SQL
1 vote211 views2 answers
Check if word is in column sql
SQL
17 votes267 views6 answers
MySQL ORDER BY
SQL
0 vote352 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote202 views2 answers
How to check if a column exists in a SQL Server table?
SQL
-1 vote195 views1 answer
How to use update trigger in sql
SQL
10 votes218 views1 answer
All_dependencies
SQL
4 votes221 views1 answer
Mysql ip address data type
SQL
1 vote197 views3 answers
Sql server get week dates from week number
SQL