mysql - ruby on rails mysql 数组中的全文相关性分数

Question

我有一个 (mysql-) 表，其中包含两列的全文索引 --> 名字，中间名。

当我使用 SQl 时

SELECT firstname, middlename, MATCH (firstname, middlename) as score AGAINST ('Peter') FROM database.tbl_names where MATCH (firstname, middlename) AGAINST ('Peter')

我得到 3 列 --> 名字、中间名和分数。

但是当我像 ruby​​ 一样尝试它时

TblName.find(:all, :select => "firstname, middlename, match(firstname, middlename) against ('Peter')as score", :order => 'score desc', :conditions => ['match(firstname, middlename) against (?)', 'Peter'], :limit => 20)

我只得到一个有两个“列”但没有“匹配列”的数组

<TblName firstname: "Peter", middlename: "">

我搜索并尝试了整个星期天，但没有找到数组中“匹配列”的解决方案。

有人可以帮帮我吗？

提前致谢!!!

Answer 1

Rails 4 版本:

Model.select("*, MATCH(title) AGAINST ('keyword') AS score").where("MATCH(title) AGAINST('keyword')").reorder("score DESC").first.score