This is the existing syntax which works fine:
Code: Select all
SELECT * FROM products,categories,sub_categories
WHERE products.approved = 1
AND products.main_category = categories.id
AND products.sub_category = sub_categories.id Code: Select all
MATCH(product_name,code,tag_1,tag_2,tag_3,tag_4,tag_5,details)
AGAINST ('keyword') AS score FROM products
WHERE MATCH(product_name,code,tag_1,tag_2,tag_3,tag_4,tag_5,details) AGAINST('keyword') Code: Select all
SELECT * FROM products,categories,sub_categories
WHERE products.approved = 1
AND products.main_category = categories.id
AND products.sub_category = sub_categories.id
AND MATCH(product_name,code,tag_1,tag_2,tag_3,tag_4,tag_5,details)
AGAINST ('keyword') AS score FROM products
WHERE MATCH(product_name,code,tag_1,tag_2,tag_3,tag_4,tag_5,details) AGAINST('keyword')