regex search a mysql text column
- by Ian
Okay, I thought my head hurt with regular regex, but I can't seem to find what I'm looking for with regexp in mysql.
I'm trying to look for situations in news articles where a Textile-formatted url has not ended with a slash so:
"Catherine Zeta-Jones":/cr/catherinezeta-jones/ visited stack overflow is ok but
"Catherine Zeta-Jones":/cr/catherinezeta-jones visited stack overflow is not.
[just used Catherine as an example because I'm assuming an alpha search wouldn't catch the hyphen]
One of these days I'll have to do that goat sacrifice so I can gain the proper knowledge of regex.
Thanks everyone!