Sort alphabeticaly and limit

Question

I have problem with sorting users by name and getting next item. How to get users with name < "Alf" i.e. users with names "Big", "Bob","Rob" etc. ? And for another example name < "Big", so users with names "Bob","Rob" will get selected.

How can I get sorted users by name with where query applied?

Answer 1

Try following,

User.where('name > ?', 'Big').order(:name)