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

0 vote192 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote221 views1 answer
Microsoft word insert sql code
SQL
-1 vote211 views1 answer
Mysql select count if contains
SQL
4 votes238 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote193 views1 answer
Oracle shrink table
SQL
0 vote190 views1 answer
Wp_query raw sql
SQL
0 vote189 views1 answer
Sql trim whitespace
SQL
2 votes193 views1 answer
Oracle table size
SQL
0 vote194 views1 answer
Show create table in postgresql
SQL
0 vote182 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL