>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
>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.
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