CODEWITHSUNDEEP
mysql
Amy Neville
Amy Neville

Reputation: 10621

Match Against Left Outer Join

SELECT p.product_id,p.account_id,i.image_id,a.email,p.title,p.price
FROM products AS p
LEFT OUTER JOIN products_images AS i
ON p.product_id = i.product_id AND i.featured=1 AND i.deleted=0
INNER JOIN accounts AS a
ON p.account_id = a.account_id
MATCH(p.title) AGAINST('+images')

I'm trying to use a MATCH for the first time. It says that I have a syntax error and I am not sure why?

Upvotes: 0

Views: 37

Answers (1)

Barmar
Barmar

Reputation: 782166

You're missing the WHERE keyword before conditions that aren't part of the join:

SELECT p.product_id,p.account_id,i.image_id,a.email,p.title,p.price
FROM products AS p
LEFT OUTER JOIN products_images AS i
ON p.product_id = i.product_id AND i.featured=1 AND i.deleted=0
INNER JOIN accounts AS a
ON p.account_id = a.account_id
WHERE MATCH(p.title) AGAINST('+images')

Upvotes: 2

Related Questions