Re: Join based upon LIKE

[Johan De Meersman]

----- Original Message -----
> From: "Jerry Schwartz" <jerry@stripped>
> 
> 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.

Apart from that, you have my deepest sympathy. I hope you can wake up from the nightmare
soon :-)

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