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 vote349 views1 answer
Mysql sort by date column
SQL
4 votes372 views1 answer
Datepart postgres
SQL
2 votes399 views2 answers
Mysql compare datetime to another datetime
SQL
6 votes383 views3 answers
Mysql remove user privileges
SQL
0 vote374 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote370 views1 answer
Where name ends in SQL
SQL
0 vote369 views2 answers
Postgresql gset
SQL
3 votes347 views3 answers
Into in sql
SQL
1 vote360 views1 answer
Vagrant mysql downgrade version
SQL
13 votes396 views2 answers
Oracle select into and inner join
SQL