View Single Post

  #5 (permalink)  
Old 14-04-2008, 12:37 PM
Briask's Avatar
Briask Briask is offline
Wannabe Geek
 
Join Date: Feb 2008
Location: Dublin
Posts: 132
Nominated 1 Time in 1 Post
TOTW/F/M Award(s): 0
Briask will become famous soon enough
Default

You need to add more rows to the table or change the query.

MySQl has a 50% threshold on the Match Against construct meaning that if your query matches more than 50% of the rows in the table it does not consider the match relevant so it does not return the rows.

So you add more rows without the text you are querying for and you'll get results ...

Or you can use the "In boolean mode" by changing your query to
Code:
SELECT poisonId, poison, latin_name, short_desc, status 
FROM tblpoisons
WHERE MATCH (poison,latin_name,short_desc,full_desc) 
AGAINST ('%poison%' in boolean mode)
Reply With Quote