need some input?

[flux]

Hi guys,
Using 5.0.22 version, I found problems with boolean mode in full text search on more then one column. When looking for Ford AND Escort i have as query:

SELECT *, MATCH (Titel,Tekst) AGAINST ('+ford+escort') AS Score FROM artikelen WHERE MATCH (Titel,Tekst) AGAINST ('+ford+escort') ORDER BY Score DESC LIMIT 0,100

But as result pages I get results with only Ford or Escort in it, in stead of Ford AND Escort. Any thoughts of which mistake am I making? Please reply.
Thank you so much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Reed]

Adding IN BOOLEAN MODE to your MATCH clause should solve your problem. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --