>-----Original Message-----
>From: Johan De Meersman [mailto:vegivamp@stripped]
>Sent: Thursday, April 28, 2011 4:18 PM
>To: Jerry Schwartz
>Cc: mysql mailing list
>Subject: Re: Join based upon LIKE
>
>
>----- Original Message -----
>> From: "Jerry Schwartz" <jerry@stripped>
>>
>> No takers?
>
>Not willingly, no :-p
>
>This is a pretty complex problem, as SQL itself isn't particularly well-
>equipped to deal with fuzzy data. One approach that might work is using a
>fulltext indexing engine (MySQL's built-in ft indices, or an external one
>like
>Solr or something) and doing best-fit matches on the keywords of the title
>you're looking for.
>
[JS] This isn't the only place I have to deal with fuzzy data. :-( Discretion
prohibits further comment.
A full-text index would work if I were only looking for one title at a time,
but I don't know if that would be a good idea if I have a list of 10000
titles. That would pretty much require either 10000 separate queries or a
very, very long WHERE clause.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
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
