[RESOLVED] select * question

[aniket_dj]

Hi all,

I have a db called "core_set" which has a bunch of tables in it.

Basically I want to search for a table named "x" or "xx" or "xxx" inside db "core_set". I am scripting using PHP, but I guess this is purely a (My)SQL question.

I was hoping for something like

select *from db(core_set) where tables_in_core_set like '%x%';

right now 'show tables' returns me the names of tables, but I cant have select *from show tables as such.

Any ideas of how I can get around this?

Thanks!

[tomhath]

Really not sure why you need to do this. But every MySQL server has an INFORMATION_SCHEMA database you could read.

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'core_set' and TABLE_NAME like '%x%'

[aniket_dj]

Thanks a ton!!!

That worked

[bradgrafelman]

Don't forget to mark this thread resolved.