Reputation: 6820
I am trying to do the following serach
As You will be able to see I am fullsearching a number of different rows from different tables.
SELECT *,
group_concat(offer ORDER BY offer_value DESC SEPARATOR ',') as offers,
group_concat(offer_value ORDER BY offer_value DESC) as offer_value,
MATCH (approved_business.tradingname,business_stores.suburb) AGAINST ('lol') AS score
FROM approved_business, business_stores, Real_Cash_Offers
WHERE approved_business.id = business_stores.business_id
AND Real_Cash_Offers.business_id = approved_business.id
AND Real_Cash_Offers.storeid = business_stores.storeid
AND MATCH (approved_business.tradingname,business_stores.suburb) AGAINST ('lol')
GROUP BY id ORDER BY offer_value DESC
The issue I am having is the following
Incorrect arguments to MATCH
Upvotes: 0
Views: 382