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 vote278 views1 answer
Spring boot mysql connection properties
SQL
-1 vote283 views2 answers
Sql truncate number
SQL
24 votes270 views6 answers
Rename a column in sql server
SQL
1 vote273 views1 answer
Oracle undo usage per session
SQL
0 vote259 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
4 votes250 views2 answers
Tables in sql
SQL
1 vote257 views1 answer
Error code 1055
SQL
8 votes277 views1 answer
Oracle add datafile to tablespace
SQL
0 vote287 views2 answers
Postgresql variable in query
SQL
1 vote272 views1 answer
Postgresql pass array in function
SQL