MySQL Forums
Forum List  »  Full-Text Search

Full text search, overriding reserved keywords
Posted by: James Greene
Date: August 29, 2006 04:36PM

I have the following query that fails to work correctly.

SELECT * FROM myTable WHERE MATCH(state) AGAINST('OH' IN BOOLEAN MODE);

This query does not return results.

However, the following query works.
SELECT * FROM myTable WHERE state='OH'; // While this works it still takes too long considering the 1 Million record count in the table

It is only for a few select state abbreivations that I am having this problem.
I am assuming that this is some reserved keyword with mySQL and its disallowing it.
I could rename the state abbreviations that fail or sort by the actual state name instead of the abbreviation, but I would rather find a route that allows me to use the match against on the abbreviations without changing data.

Any help would be greatly appreciated!

Options: ReplyQuote


Subject
Views
Written By
Posted
Full text search, overriding reserved keywords
4554
August 29, 2006 04:36PM


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.