[ashitpro]

Hello everybody,

I've strange situation here, May be MySql experts could help me out.
I've a table with single column, named 'exp', which contains the preloaded regular expressions. Now, I have string(URL) and I want to find out whether this url could be matched by any one of this 'exp'.

I tried something like this...
[code=mysql]
select 'my_url' REGEXP in (select exp from my_table);
[/code]
naturally it didn't work....

any solutions?
it would be great If we could manage this in single query.
Two queries would be fine...But not more than that...

Regards,
Ash

[Atli]

Hi.

Did you try:
[code=mysql]
SELECT regexp_str FROM regTable
WHERE 'your_url' REGEXP regexp_str
[/code]

[ashitpro]

Originally Posted by Atli

Hi.

Did you try:
[code=mysql]
SELECT regexp_str FROM regTable
WHERE 'your_url' REGEXP regexp_str
[/code]

It worked.....
Thanks