>From: Johan De Meersman [mailto:vegivamp@stripped]
>Sent: Sunday, May 01, 2011 4:01 AM
>To: Jerry Schwartz
>Cc: Jim McNeely; mysql mailing list
>Subject: Re: Join based upon LIKE
>----- Original Message -----
>> From: "Jerry Schwartz" <jerry@stripped>
>> I shove those modified titles into a table and do a JOIN ON
>> `prod_title` LIKE
>Roughly what I meant with the shadow fields, yes - keep your own set of data
>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.
[JS] I've thought about using soundex(), but I'm not quite sure how.
I didn't pursue it much because there are so many odd terms such as chemical
names, but perhaps I should give it a try in my infinite free time.
>Apart from that, you have my deepest sympathy. I hope you can wake up from
>nightmare soon :-)
[JS] Thanks for your condolences.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>Bier met grenadyn
>Is als mosterd by den wyn
>Sy die't drinkt, is eene kwezel
>Hy die't drinkt, is ras een ezel