thboob Posted November 22, 2009 Share Posted November 22, 2009 I need to allow users to search for last names in my database. Some of these names contain the ' character .... for example O'Reilly Is it possible to ignore this character, in the DB field, when comparing the user's query with the DB entry? In other word if the user searches for Oreilly or O'Reilly it returns the database entry O'Reilly Quote Link to comment Share on other sites More sharing options...
rajivgonsalves Posted November 22, 2009 Share Posted November 22, 2009 you can use the SOUNDEX function Quote Link to comment Share on other sites More sharing options...
fenway Posted November 25, 2009 Share Posted November 25, 2009 FULLTEXT will ignore most of these characters, but comes with it's own issues. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.