PHP MYSQL FULLTEXT - Search problem with Apostrophe - ideas?
Posted: Thu Jul 13, 2006 8:23 pm
Hi all
I have a search form that searches my database for the query string using mysql's match and boolean.
The problem I found is this:
Say I have a record: Micheal's Fine Foods
Well if I search for micheal OR micheal's OR micheals no results are found. Yet, if I search for micheals fine foods, it will show the row with every other row that has the words fine or foods.
Is there any way to overcome this? Without having to replace every apostrophe in the database?
Any input appreciated... I need to fix this.
Thank you in advance!
I have a search form that searches my database for the query string using mysql's match and boolean.
The problem I found is this:
Say I have a record: Micheal's Fine Foods
Well if I search for micheal OR micheal's OR micheals no results are found. Yet, if I search for micheals fine foods, it will show the row with every other row that has the words fine or foods.
Is there any way to overcome this? Without having to replace every apostrophe in the database?
Any input appreciated... I need to fix this.
Thank you in advance!