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 :|
--
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]
