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 <[EMAIL PROTECTED]> 05/29/03 08:15pm >>> 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]