Need help with REGEXP 1

[elsenorjose]

Ok, so I searched the forum and I can't figure out how to modify something for my use. I'm having a hard time writing a regular expression in my query. Here's some sample data:

http://www.somewebsiteaddress.com/subdirectory/anothersub/portid:12345

http://www.somewebsiteaddress.com/s.../portid:12345?Make=Ford&Model=Focus&Color=Red

I'm trying to do a comparison of URLs that have query arguments after the 'portid:12345' section vs. URLs that don't. The 5 digits after 'portid:' will change so I can't just hard code

...url like '%portid:12345'

The good news is that's a pretty consistent pattern; in other words, portid: followed by 5 digits is how this appears in all URLs. Can someone help me with this?

Thanks.

 

[rac2]

You might try

... WHERE url REGEXP '%portid:[0-9]{5}%'

meaning the url matches the regular expression. The regular expression is intended to be
% = anything
portid: = exactly that, portid:
[0-9] = a number
{5} = repeated 5 times

This I gleaned from reading the following

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html

I have no idea whether it will work.

 

[elsenorjose]

Small tweak but I got it...

WHERE url REGEXP '/portid:[0-9]{5}$'

We had to indicate that it was at the end of the strong with the '$' sign and that portid was preceded by a '/'

Thanks for the brainstorm though!