MySQL Forums
Forum List  »  Newbie

similar string matches
Posted by: debbie
Date: August 20, 2004 04:25PM

What would be the best way to do this?

I am allowing visitors to add their information to a database via a web form. One field they fill in is the name of their high school. I can see some adding it as 'Sandburg' and some as 'Carl Sandburg' and others as 'Carl Sandburg High School'. Visitors can also search the database. Is there a mySQL function I can set up so when someone puts in any of these three versions of the high school name, all 'similar matches' will be returned?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
similar string matches
August 20, 2004 04:25PM
August 21, 2004 08:29AM
August 23, 2004 09:08AM


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.