Hi,
I try to use boolean search into my database but I sometimes estonished of
the results.
I make such query :
SELECT * FROM T_Stories WHERE match
(Summary,Content,Heading,livecountry,livecity,Author) against ('fiat' IN
BOOLEAN MODE) AND Verified = 'Y' LIMIT 12
I can retrieve rows that have fiat in the matches column :
(Summary,Content,Heading,livecountry,livecity,Author).
Bu when I make +fiat, it s ok :
SELECT * FROM T_Stories WHERE match
(Summary,Content,Heading,livecountry,livecity,Author) against ('+fiat' IN
BOOLEAN MODE) AND Verified = 'Y' LIMIT 12
I have the rows I wanted.
As I see in the doc + isnt mandatory :
apple banana
find rows that contain at least one of these words.
So no rows for fiat alone.
But with the word notpresent which is not present in my rows, the query :
SELECT * FROM T_Stories WHERE match
(Summary,Content,Heading,livecountry,livecity,Author) against ('fiat
notpresent' IN BOOLEAN MODE) AND Verified = 'Y' LIMIT 12
return rows that have fiat inside, the sames that +fiat have ?!
I thinks it s not normal or there is a misunderstanding ?
Thanks.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
