mySQL and the grand regexp retardedness with lettercasing
19 September 2009
I wanted to find a list of Firefox addons that had smushed text in their title.
E.g. FireBug or StumbleUpon. The normal porter stemming algorithm that Sphinx
uses does not turn “StumbleUpon” into “stumbl upon” as it would with “Stumble
Upon”. I was hoping for, and unfortunately could not find a method to do a
regular expression search/replace using mysql. If I could, I could have Sphinx
read “StumbleUpon” as “Stumble Upon” and all would be well (although in theory
this would backfire).
Read full post