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 vote149 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote175 views1 answer
Postgres extract number from string
SQL
1 vote148 views1 answer
Sql random sampling per group
SQL
1 vote132 views1 answer
Temp table vs variable table in sql server
SQL
0 vote149 views1 answer
Postgresql import data from csv
SQL
2 votes144 views1 answer
How to show the whole table in sql
SQL
1 vote143 views1 answer
Find difference in dates sql
SQL
1 vote133 views1 answer
Sql drop with dependencies
SQL
0 vote128 views1 answer
Mariadb number format
SQL
1 vote146 views1 answer
Import sql file mysql commadn line
SQL