Full text search, overriding reserved keywords
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!
Subject
Views
Written By
Posted
Full text search, overriding reserved keywords
4525
August 29, 2006 04:36PM
2580
August 30, 2006 10:34AM
2611
August 30, 2006 11:23AM
3039
August 30, 2006 03:35PM
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.