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 vote210 views1 answer
Select last row from SQL Table
SQL
0 vote213 views1 answer
Python connect to mysql in settings.py
SQL
0 vote209 views1 answer
Count number of entires by months sql
SQL
0 vote265 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote212 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote250 views1 answer
Sql query for login with email or username
SQL
1 vote270 views1 answer
Difference between where and having clause
SQL
0 vote206 views1 answer
Power query case when
SQL
1 vote212 views2 answers
Oracle 18c xe ORA-65096
SQL
4 votes217 views4 answers
Pl sql output
SQL