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 https://forums.phpfreaks.com/topic/182511-search-and-compare/ 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 https://forums.phpfreaks.com/topic/182511-search-and-compare/#findComment-963297 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 https://forums.phpfreaks.com/topic/182511-search-and-compare/#findComment-965657 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.