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

8 votes141 views1 answer
Oracle search stored procedures for text
SQL
0 vote146 views1 answer
Command line mysql xampp
SQL
1 vote106 views1 answer
Sql convert month name to number
SQL
1 vote131 views2 answers
Oracle list service names
SQL
0 vote135 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote131 views1 answer
Sql select min row
SQL
2 votes131 views2 answers
Sql query to copy data from one column to another
SQL
0 vote131 views1 answer
Create-table-with-index-organization
SQL
0 vote126 views3 answers
Between keyword sql
SQL
1 vote121 views1 answer
Mysql login console
SQL