全文搜索PHP

Question

我正试着做以下的说教

正如您将看到的，我正在从不同的表中完整地搜索多个不同的行。

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

我遇到的问题是：

不正确的参数以匹配

Answer 1

MATCH (...)中的所有列都必须来自同一个表。