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 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 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. Link to comment https://forums.phpfreaks.com/topic/182511-search-and-compare/#findComment-965657 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.