php - 是否可以对连接的列执行全文搜索？

Question

您好，我正在尝试从连接的列中进行选择:

SELECT 
   A.idAd,
   A.ads_in_Cat,
   A.title,
   A.currency,
   A.price,
   A.in_dpt,
   A.description,
   D.*, 
   S.* 
FROM ads A
LEFT JOIN dept D ON D.id_dept = A.in_dpt
LEFT JOIN sub_cat_ad AS  ON S.id_sub_cat = A.ads_in_Cat
WHERE MATCH(A.title, A.description) AGAINST(:searchTerm) 
   OR MATCH (S.sub_cat_name) AGAINST(:searchTerm) 

有人能告诉我为什么 MySQL 返回:1191 找不到与列列表匹配的 FULLTEXT 索引......除非我使用 IN BOOLEAN MODE？

PS 表 S 的每一列都定义了全文。 MySQL 版本 5.1.49

Answer 1

你在使用时是否仍然报错:

   SELECT A.idAd,
          A.ads_in_Cat,
          A.title,
          A.currency,
          A.price,
          A.in_dpt,
          A.description,
          D.*, 
          s.* 
     FROM ads A
LEFT JOIN dept D ON D.id_dept = A.in_dpt
LEFT JOIN sub_cat_ad s ON s.id_sub_cat = A.ads_in_Cat
                      AND MATCH (s.sub_cat_name) AGAINST(:searchTerm) 
    WHERE MATCH(A.title, A.description) AGAINST(:searchTerm)