[UPHPU] MySQL question

Scott Hill llihttocs at gmail.com
Fri May 18 16:17:29 MDT 2007


On 5/18/07, Webot Graphics <graphics at westernbotanicals.com> 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.
>
> Justin Giboney


We need more info.  What is it that leads you to believe that it doesn't
work?  Did you get an error or just no data?

-- 
Scott Hill

"May you solve interesting problems" - Author Unknown
"A fanatic is one who can't change his mind and won't change the subject." -
Sir Winston Churchill


More information about the UPHPU mailing list