Re: Join based upon LIKE

[Johan De Meersman]

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

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel