MySQL Forums
Forum List  »  Full-Text Search

FULLTEXT searching woes - why does this happen
Posted by: Ter Chrng Ng
Date: September 28, 2008 08:51AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
FULLTEXT searching woes - why does this happen
3842
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.