Shaun wrote:
Hi,
I have a query where I select all table names where the table name has PID_1
in i.e.
SHOW TABLES LIKE '%PID_1%';
However there may be cases where I need to search for tables where the table
name is PID_1 or PID_2. In MySQL this can't be done in one query, so how can
I do two queries and combine the result set so I can loop through it?
Thanks for your help
SHOW TABLES REGEXP 'PID_[0-9]+';
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
