>-----Original Message----- >From: Johan De Meersman [mailto:vegiv...@tuxera.be] >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" <je...@gii.co.jp> >> >> 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. > [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 >the >nightmare soon :-) > [JS] Thanks for your condolences. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org