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 vote143 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote164 views3 answers
Fetlife
SQL
0 vote115 views1 answer
Raven ql select count
SQL
18 votes151 views2 answers
Sql inner join
SQL
0 vote172 views1 answer
Mysql dump with table query
SQL
41 votes233 views6 answers
Alter table add column in SQL Server
SQL
0 vote138 views1 answer
Drop all tables in azure sql database
SQL
7 votes157 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote154 views1 answer
Psql get table data types
SQL
0 vote149 views1 answer
Oracle SQL join three tables and group by column
SQL