Posted by Shaun on 02/02/05 15:35

Hi guys,

Thanks for your replies but neither UNION or REGEXP can be used with SHOW
TABLES...

Any ideas?

"Jochem Maas" <jochem@iamjochem.com> wrote in message
news:41F77BC0.1040701@iamjochem.com...
> Marek Kilimajer wrote:
>> 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]+';
>>
>
> nice! :-)

[Back to original message]