按以数字开头的字符串排序 - ActiveRecord

2021-10-26 00:00:00 ruby-on-rails mysql activerecord natural-sort

我正在构建 Rails 应用程序并尝试按以数字开头的字符串列对数据库中的记录进行排序.
怎么先按号码下单?
我宁愿按 SQL 顺序排序，也不愿按 ruby​​ 方法排序.有什么办法吗?

I'm building Rails app and trying to order records in database by string column that starts with number.
How can I order by the number at first?
I'd rather ordering as SQL order than sorting by ruby method. Is there any way?

expected order
1.record1
2.record2
10.record10


present order
1.record1
10.record10
2.record2

推荐答案

您可以order by field + 0 改变field的数据类型code> 隐式转换为一个数字:

You could order by field + 0 to change the data type of field to a number implicitly:

Model.order("field + 0 ASC")

# similar `string`.to_i in Ruby
# `1.record1`   => 1
# `10.record10` => 10

相关文章