Getting two queries into one result set
| From: | Shaun | Date: | Wed, 26 Jan 2005 11:03:44 +0000 |
| Subject: | Getting two queries into one result set | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-207364@lists.php.net to get a copy of this message | ||
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