我正在尝试搜索"页面标题"或"内容"列以查找搜索词"短语"和其中列"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
,以便狮身人面像获取数据以将其包含在索引中!