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

Ordering by String that starts with Number - ActiveRecord(按以数字开头的字符串排序 - ActiveRecord)

问题描述

我正在构建 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

这篇关于按以数字开头的字符串排序 - ActiveRecord的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！