我设法通过用另一个查询包围当前查询并将ORDER BY RANK拉到外部查询来解决该问题。像这样:
SELECt * FROM (SELECt 4*SCORE(1) + 2*SCORE(2) + SCORE(3) AS RANK FROM images i WHERe ConTAINS(i.subject, 'testing', 1)>0 OR ConTAINS(i.place, 'testing', 2)>0 OR ConTAINS(i.description, 'testing', 3)>0)ORDER BY RANK;
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)