Daniel Rossi <[EMAIL PROTECTED]> wrote:
> i have also noticed that the boolean default is OR how can i explicitly set it to
> AND like i'd like both exact matches in the search currently its exact match 1 or
> exact match 2 :|
>
>>>> Daniel Rossi <[EMAIL PROTECTED]> 05/29/03 01:23pm >>>
> i am getting people to try and break a search engine i built , when we put in the
> word DB into the search query i get no results even if its there in the record , why
> is this ?
>
> WHERE MATCH (sl.shotlist , sl.slug , sl.summary) AGAINST ('DB' IN BOOLEAN MODE)
> LIMIT 0 , 10 ;
>
> also how come this doesnt work for the above syntax ?
>
> "word1 word2" "word3 word4" , i cant seem to get exact matches more than once :|
>
It's not a bug, by deafult variable ft_min_word_len=4, but you search word 'DB' has
length 2.
If you want to search both exact matches use + operator in BOOLEAN MODE or phrase
search:
http://www.mysql.com/doc/en/Fulltext_Search.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
