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 vote183 views1 answer
Mysql random limit 1
SQL
0 vote203 views1 answer
Xampp mysql version
SQL
1 vote176 views1 answer
PLS-00225 type
SQL
4 votes189 views2 answers
Mysql select where starts with
SQL
2 votes191 views1 answer
Sql ignore accents
SQL
1 vote208 views1 answer
Mysql select for update ejemplo
SQL
0 vote351 views1 answer
Mysql delete entire row on condition
SQL
0 vote202 views1 answer
Sqlite löschen einer tabelle
SQL
4 votes208 views1 answer
For loop postgresql
SQL
1 vote219 views1 answer
Limit offset order by mysql
SQL