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

21 votes129 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote163 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote123 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote161 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
2 votes119 views2 answers
Compare date mysql
SQL
0 vote133 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote133 views1 answer
How to save data in database in mysql node
SQL
0 vote130 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote123 views1 answer
Soql more than today
SQL
9 votes130 views2 answers
SELECT User,Host FROM mysql.user;
SQL