Fulltext search not returning results on specific keyword
Hi all!
To begin, I am new to MySQL/SQL in general...so please excuse any silly questions or misnomers!
So the issue is this...I have the following query:
SELECT * FROM $mainsection WHERE MATCH(MAKER,ORIGIN,DEV_1,DEV_2,DEV_3,DEV_4,DEV_5) AGAINST ('%$search_term%')
The problem is related to the ORIGIN field. This field represents country of origin, and obviously has a number of different possible values. A significant proportion of the table has 'England' as it's ORIGIN value, yet if I search for 'England' or 'england' the search returns no results. The strange thing is that if I search for any other ORIGIN value present in the table, the results are returned correctly. The fields being searched all have fulltext index, and any other relevant search queries work perfectly well.
It's starting to appear to me that the fulltext index may be anti-england :)
Any help or suggestions would be immensely appreciated!
A few tech details:
DB Engine: MyISAM
MySQL Version: 5.1.47-community
Thanks in advance
Tim
Subject
Views
Written By
Posted
Fulltext search not returning results on specific keyword
6054
June 17, 2010 04:22PM
2614
June 17, 2010 04:34PM
2180
June 20, 2010 08:34PM
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.