使用列筛选进行狮身人面像全文搜索


sphinx fulltext searching with column filtering

我正在尝试搜索"页面标题"或"内容"列以查找搜索词"短语"和其中列"class_key" === "modDocument"。

目前没有返回任何内容

.PHP

$sphinx = new SphinxClient();
$sphinx->setMatchMode(SPH_MATCH_EXTENDED2);
$query = $sphinx->Query('"phrase" @class_key modDocument', 'myIndex');

如果我从查询中删除"@class_key modDocument",我会得到结果

狮身人面像

source myIndex : src {
    sql_query_range = SELECT MIN(id), MAX(id) FROM tx3nh_site_content
    sql_query = SELECT id, pagetitle, content FROM tx3nh_site_content WHERE id>=$start AND id<=$end
}
index myIndex {
    source = myIndex
    path = /home/sphinx/data/myIndex
    min_word_len = 3
    min_infix_len = 3
}
 sql_query = SELECT id, pagetitle, content FROM ...

没有列出名为class_key的列!

您需要将列添加到sql_query,以便狮身人面像获取数据以将其包含在索引中!