[UPHPU] MySQL question

[John David Anderson]

On May 18, 2007, at 3:57 PM, Webot Graphics wrote:

> How come this works
>
> SELECT * FROM Movies WHERE Movie_Title = 'X-Men'
>
> but this doesn't
>
> SELECT *, MATCH (Movie_Title) AGAINST ('X-Men') AS score FROM  
> Movies WHERE MATCH (Movie_Title) AGAINST ('X-Men')
>
> I am assuming it has something to do with the full text search, but  
> I don't know how to fix it.

If you're getting an error or something, that really helps in  
answering the question.

Have you set up a full text index on the column(s) you're matching  
against?

-- John