I have been trying to create a search query. Following is my mysql query:
SELECT id, title, SUBSTRING(description, 1, 80) AS description,price,picture,date FROM movie INNER JOIN movieLocation ON movie.id = movieLocation.movieid WHERE TRUE AND movieLocation.Location='NEW YORK'AND MATCH(movie.title, movie.description) AGAINST ('Catch me if you can');
There is an error on this mysql query. Can anyone spot it. Error exists in this "MATCH(movie.title, movie.description) AGAINST ('Catch me if you can');" section only. if i run full query without this MATCH section it works. So how can I implement this match statement to my query. Thank you.
oksam
0
Newbie Poster
smantscheff
265
Veteran Poster
What is the error message? What is the table structure?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.