Ruby on Rails Where clause less than greater than

Question

So I want to do a ruby on rails query that is structured this way with a less than and greater than constraint.

self.order('random()')
  .where(
    friends: friend,
    age: {minimum: 5, maximum: 20}
  )

The above is how I imagine it to be done, being a ruby beginner. However this does not work. How can this be correctly achieved?

Answer 1

Use a range object.

.where(age: 5..50)

Or you could write

.where('age BETWEEN 5 AND 20')

Answer 2

You can use operator also

.where("id >= ? and id <=  ?",5,20)