MySQL Forums
Forum List  »  Newbie

Re: Comparing strings
Posted by: Peter Brawley
Date: March 16, 2009 12:18PM

Ah sorry, brain cramp,

SELECT n.firstname,n.secondname
FROM names n
JOIN names a ON LOCATE(n.firstname,a.secondname) OR LOCATE(n.secondname,a.firstname)


Options: ReplyQuote

Written By
March 16, 2009 11:18AM
March 16, 2009 11:28AM
March 16, 2009 11:38AM
Re: Comparing strings
March 16, 2009 12:18PM
March 17, 2009 09:33AM
March 17, 2009 09:37AM
March 17, 2009 10:01AM
March 17, 2009 10:44AM
March 17, 2009 10:51AM
March 17, 2009 10:59AM
March 17, 2009 11:04AM
March 17, 2009 12:07PM

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.