开发者

SQL LENGTH in ActiveRecord?

开发者 https://www.devze.com 2023-01-05 09:05 出处:网络
How can I translate this MySQL\'s WHERE to ActiveRecord :condit开发者_StackOverflowion? SELECT * FROM users WHERE LENGTH(users.last_name) < 3

How can I translate this MySQL's WHERE to ActiveRecord :condit开发者_StackOverflowion?

 SELECT * FROM users WHERE LENGTH(users.last_name) < 3

Thanks!


User.find(:all, :conditions => ["LENGTH(last_name) < ?", 3])

or you can use find_by_sql

 User.find_by_sql("SELECT * FROM users WHERE LENGTH(users.last_name) < 3")
0

精彩评论

暂无评论...
验证码 换一张
取 消