>-----Original Message----- >From: Johan De Meersman [mailto:vegiv...@tuxera.be] >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" <je...@gii.co.jp> >> >> 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: 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
