hi sorry to got this , ok
say i search for this "something1 something2" + "something3 something4" that doesnt work
either is the syntax correct ?
>>> Egor Egorov <egor.egorov@stripped> 05/29/03 08:15pm >>>
Daniel Rossi <daniel.rossi@stripped> 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 <daniel.rossi@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ 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/mysql?unsub=1
