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 vote215 views1 answer
Sql only five first row
SQL
4 votes248 views3 answers
Employee name starting with in sql
SQL
2 votes196 views1 answer
Foreign key example in dbms
SQL
1 vote215 views1 answer
Oracle create program if no exists
SQL
0 vote270 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote262 views1 answer
Sqlalchemy _in array sqlite
SQL
7 votes277 views1 answer
Show line number in sql server
SQL
0 vote258 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote216 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote234 views1 answer
Psql lst trigger
SQL