MySQL Forums
Forum List  »  Full-Text Search

Using JOIN a ON a.field SOUNDS LIKE b,field
Posted by: George Brooks
Date: October 07, 2010 04:44PM

If this is posted incorrectly, please advise.

In an effort to avoid duplicating names in a PHP application, I'm using a SQL statement that includes the phrase "join organizations o2 on o1.organization sounds like o2.organization where o2.organization=$orgname". (o1 and o2 are the same table.) What I cannot understand is why if $orgname = 'Truckee Donner Historical Society' I will get existing misspellings of the name (e.g., 'Truckee-Donner Historical Society', where there's an added hyphen), but if $orgname='Truckee Donner Histerical Society' (an organization that does not exist in the table) I get an empty result set. Yet when I compare the soundex values of the two possibilities they are identical.

If there is a better approach to this problem, please let me know.

Many thanks.


Options: ReplyQuote

Written By
Using JOIN a ON a.field SOUNDS LIKE b,field
October 07, 2010 04:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.