Re: Getting two queries into one result set
| From: | Marek Kilimajer | Date: | Wed, 26 Jan 2005 11:12:23 +0000 |
| Subject: | Re: Getting two queries into one result set | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-207367@lists.php.net to get a copy of this message | ||
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 helpSHOW TABLES REGEXP 'PID_[0-9]+';