Page 1 of 1

Excluding tables from SHOW TABLES FROM function

Posted: Thu Oct 12, 2006 4:22 pm
by reecec
hi,

Is there any easy way to exclude a table from the list when I use the

Code: Select all

SHOW TABLES FROM
function.


Thanks Reece

Posted: Fri Oct 13, 2006 5:27 am
by volka
http://dev.mysql.com/doc/refman/5.0/en/show-tables.html wrote:SHOW [FULL] TABLES [FROM db_name] [LIKE 'pattern']
you can formulate a "negative" regular expression to exclude the table.

Posted: Thu Oct 19, 2006 1:18 pm
by reecec
what for use in php?

as i tryed this but recived an error.

Thanks reece

Posted: Thu Oct 19, 2006 1:29 pm
by Luke
for use in your query... you can use regex in queries... it's dreadfully slow though so I've heard. (don't know for sure) and I imagine it wouldn't be such a big deal for tables as opposed to records where there could potentially (and reasonably) be millions.