Regular expression in MySql....

[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...

select 'my_url' REGEXP in (select exp from my_table);
 

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:

SELECT regexp_str FROM regTable
WHERE 'your_url' REGEXP regexp_str
 

[ashitpro]

Hi.

Did you try:

SELECT regexp_str FROM regTable
WHERE 'your_url' REGEXP regexp_str
 

It worked.....
Thanks