mysql select tables with name like

Solutions on MaxInterview for mysql select tables with name like by the best coders in the world

showing results for - "mysql select tables with name like"

1SELECT table_name
2FROM information_schema.tables

1select table_schema as database_name,
2    table_name
3from information_schema.tables
4where table_type = 'BASE TABLE'
5    and table_name like 'cu%'
6order by table_schema,
7     table_name;
8

similar questions

select 2a from table where name like search column by name mysql get record which is available in one table but not in another mysql get foreign table names mysql mysql create table from select statement mysql like search for tables with name postgresql mysql find tables with column name mysql like 28searching in the string 29 select table name from user tables 3b mysql copy table with new name mysql get column names from table mysql get only the field names in a table mysql find tables with name how to create a table based on another table in mysql how to query all tables mysql at the same time like in mysql mysql search for column name in all tables mysql select where field like in list mysql like sql select column name like from multiple tables find tables with column name in sql mysql like in mysql select all table that have field names mysql search like but first exact match get all tables using like how to check table name in current database sql

queries leading to this page

select tables like mysql select tables with name like mysql mysql select all tables with name like show all mysql tables where table name like mysql select where tablename like select table like mysql mysql show tables where name like mysql select tables with name like mysql select tables with name like