FULLTEXT match against

[wheelie34]

Hi

I have a fulltext column that contains many word, I am passing $search to it which has 3 words in it currently it finds all entries containing the 3 words but lists entries that also have one or 2 of the words here is my mysql request
mysql_query("SELECT * FROM addresses WHERE MATCH(title) AGAINST('$search')")

How do I get it ot only show entries which contain all 3 words only?

any help greatly appreciated

[henry0]

Try:
WHERE MATCH .....AGAINST(your 3 words or 3 $var)

<edit>
I mean all three and not one that represents a whole
bunch of words
</edit>

<edit_2>
Once I saved a tutorial HERE [zend.com]
</edit_2>

[soflution]

use IN BOOLEAN MODE and insert and between terms