Need help with search engine

[eluser]M4rc0[/eluser]
Thanks for your reply manilodisan!

With "QUERY EXPANSION IN BOOLEAN MODE":

Code:

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN BOOLEAN MODE)' at line 1

SELECT * FROM movies WHERE MATCH (name,opinion) AGAINST ('test' WITH QUERY EXPANSION IN BOOLEAN MODE);

And with just "BOOLEAN MODE" it still brings all the rows.

Now I'm matching just name and opinion fields to avoid the query expansion to bring up too much, but it still brings it all.