MySQL Forums
Forum List  »  Newbie

query just against next record
Posted by: morgan
Date: June 03, 2005 09:33PM

I want to run a query to see if one field is a subset of another field. Is there a way to check if one record's field is a subset of the next record's field's value.

Specifically, I'm checking for duplicates in the database, and want to find (eg) Rob Smith == Robert Smith. So I'm going to make one field with last name + first name to get SmithRob and SmithRobert. Once I order them on that new field, SmithRob will be right before SmithRobert, and I want to flag the records where one record is a subset of the next record.

Is this possible??

Thanks,

Morgan

Options: ReplyQuote


Subject
Written By
Posted
query just against next record
June 03, 2005 09:33PM


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.