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.
Justin Giboney