Re: REGEXP problems

[Felix Geerinckx]

Emily Frazier wrote:
> I'm searching through a table called "Subjects" for the string "Social Sciences". However, I also
> hav ea subject in this table called "Science". So when I do the regexp it does both...but I want it
> to strictly only accept exact matches.

From the example "Social SciencesHistoryArt" in your original post I suppose you cannot use the word boundary markers [[:<:]], [[:>:]] (see http://dev.mysql.com/doc/mysql/en/regexp.html).

So I would suggest you add another column 'seen' to your table and set it when you encounter a match, so you can ignore the record with the next regex. Then start matching from long to short (i.e. first Social Sciences, then Science).

--
felix
Please use BBCode to format your messages in this forum.