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
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
