Rails: Using greater than/less than with a where statement

ruby-on-rails syntax where
Adam Templeton picture Adam Templeton · Jul 3, 2012 · Viewed 119.8k times · Source

I'm trying to find all Users with an id greater than 200, but I'm having some trouble with the specific syntax.

User.where(:id > 200)

and 

User.where("? > 200", :id)

have both failed.

Any suggestions?

Answer

RadBrad picture RadBrad · Jul 3, 2012

Try this

User.where("id > ?", 200)

Related questions

Case statement with multiple values in each 'when' block

The best way I can describe what I'm looking for is to show you the failed code I've tried thus far: case car when ['honda', 'acura'].include?(car) # code when 'toyota' || 'lexus' # code end I've got about 4 or 5 different when …

Read More
Haml syntax: split a line to a couple of rows

I use HAML in my rails project for my html templates. I would like to figure out if its possible to divide a very long line and make it a couple of rows: %a.open-service{href: '#', data: { service_…

Read More
How to create Hash with string keys by default

When I do the following: h = { "a": 123 } Ruby converts the key to a symbol automatically. h[:a] # => 123 h["a"] # => nil How can I prevent this behaviour? I created the hash with a string key, and would like to …

Read More