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

4 votes163 views2 answers
How to insert ip address in mysql using php
SQL
4 votes145 views1 answer
Select nls_date_format
SQL
0 vote157 views1 answer
How to add boolean column in postgresql
SQL
0 vote159 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote166 views1 answer
Look at running processes redshift
SQL
0 vote213 views1 answer
Mysql loop through databases and execute query
SQL
2 votes190 views1 answer
Dbms transaction (psql)
SQL
1 vote143 views1 answer
Using SQL in rails migration
SQL
1 vote174 views1 answer
Sqlite update from another table
SQL
0 vote140 views1 answer
Drop all tables in azure sql database
SQL