FULLTEXT searching woes - why does this happen
When I query
SELECT * FROM csim_debitor WHERE MATCH (cust_index) AGAINST ('+SUP* ' IN BOOLEAN MODE) ORDER BY cust_no ASC LIMIT 19,20
I got matched with
SUPPLY and SUPPLIES ( this is correct)
However
When I query
SELECT * FROM csim_debitor WHERE MATCH (cust_index) AGAINST ('+SUPP* ' IN BOOLEAN MODE) ORDER BY cust_no ASC LIMIT 19,20;
I got an empty set
Note: I did rebuild the table several times.
Subject
Views
Written By
Posted
FULLTEXT searching woes - why does this happen
3960
September 28, 2008 08:51AM
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.