MySQL Forums
Forum List  »  Full-Text Search

Fulltext search not returning results on specific keyword
Posted by: Tim Bradley
Date: June 17, 2010 04:22PM

Hi all!

To begin, I am new to MySQL/SQL in 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


Options: ReplyQuote

Written By
Fulltext search not returning results on specific keyword
June 17, 2010 04:22PM

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.