How can I find out in RoR in which line a certain record is located in the database?

Question

Ruby on Rails

Let's say there is a User table with the following content in the database:
id | login
4 | my_login34
7 | my_login4
3 | my_login11
How can I make a selection from the table and find out in which line this entry is located, for example, my_login4 is in the second line, but how can I find out by making a selection from the table:
u = User.where(login: 'my_login4').first ?? ?

Answer 1

Or add a field that will contain the position of each and recalculate each time the table changes.
Or User.pluck(:login).index("my_login4")remember to index the login field
. But in general, the idea is doubtful. Why is this needed?