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.
I know that i could put a + infront of every word but thats not what i want since the query comes from a searchbox and i dont want to write som code to manipulate the indata so ite shows correctly i just want to change the default word separator from OR to AND.
Maybe it´s ft_boolean_syntax that should be changed? If so to what... please help me before i try to strangle myself :P
_________________________________________________________________
Chatt: Träffa nya nätkompisar på Habbo Hotel http://habbohotel.msn.se/habbo/sv/channelizer
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
