Trying to search for "black cat" should only return records that contains both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE);
sure there must be an easy way to change the default word separator to AND instead of OR?
I found this:
set-variable = ft_boolean_default='AND'
SET ft_boolean_default = 'AND'
But it does not work, everything would be sooo much easier if this was possible.
"black cat" is only an example and the real query comes from user input. So it can be anything like +cat -dog +"big nose" -horse white black -red
so parsing the input is not what i want, i just want to change the default word separator to AND instead of OR.
Now i´m running 4.1.10 and also tried with 4.0.24
Please help me, there must be a way to change this?!?!
_________________________________________________________________ Hitta rätt på nätet med MSN Sök http://search.msn.se/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
