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

7 votes191 views2 answers
Oracle foreign key reference table
SQL
4 votes190 views1 answer
Change nls_date_format
SQL
1 vote197 views1 answer
Oracle sql listagg
SQL
0 vote210 views1 answer
Sqlite unique multiple columns
SQL
1 vote196 views1 answer
Backup mysql data only
SQL
1 vote182 views5 answers
Sql 2nd highest salary
SQL
0 vote179 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
9 votes179 views2 answers
Default number in sql
SQL
16 votes192 views3 answers
Tsql rename column name
SQL
0 vote216 views1 answer
Sql query to find percentage of null values in a table
SQL