CODEWITHSUNDEEP
activerecordruby-on-rails
ohho
ohho

Reputation: 51921

SQL LENGTH in ActiveRecord?

How can I translate this MySQL's WHERE to ActiveRecord :condition?

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

Thanks!

Upvotes: 3

Views: 1044

Answers (1)

Salil
Salil

Reputation: 47472

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")

Upvotes: 4

Related Questions