From: Johan De Meersman Date: May 1 2011 8:00am Subject: Re: Join based upon LIKE List-Archive: http://lists.mysql.com/mysql/224919 Message-Id: <9e4e9180-c94a-486e-81c0-3c1b76183190@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Jerry Schwartz" > > I shove those modified titles into a table and do a JOIN ON > `prod_title` LIKE > `wild_title`. Roughly what I meant with the shadow fields, yes - keep your own set of data around :-) I have little more to offer, then, I'm afraid. The soundex() algorithm may or may not be of some use to you; it offers comparison based (roughly) on pronounciation instead of spelling. Apart from that, you have my deepest sympathy. I hope you can wake up from the nightmare soon :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel