At 19:20 -0400 9/13/02, Aaron Hazelton wrote:
>I have a RH Linux 7.1 running MySQL 3.23.36 and am wanting
>to do a search like this (go easy, im a newbie):
>SELECT sku, title, price, description, color, size
> FROM products
> WHERE MATCH (sku,title,description,comment)
> AGAINST ('[value query]');
>it works fine (I guess :-) but it basically does an OR search for the
>words of the query value. I have looked around the mail list and
>it seems that there is no way in this version to cause an AND
Not with a single MATCH() clause. Prior to 4.x, you can use:
WHERE MATCH(...) AGAINST(word1)
AND MATCH(...) AGAINST(word2)
but that's pretty ugly.
>Are there any alternatives, even if speed is compromised
>slightly to get the same effect?