How is the adjacent string value?

[mighty cedar]

Hello, I ran into a problem that there is no row numbering in MySQL, and I need to compare values. For example, find out what the password is for root.
Please tell me the options

[novel elm]

⌛ This post has been reserved for your question.

Hey @mighty cedar! Please use /close or the Close Post button above when you're finished. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

[cunning geode]

use the LIMIT clause in a SELECT statement to retrieve a specific number of rows from a table!

[mighty cedar]

you didn't understand, I need to get the adjacent cell value, for example:

root
output:
123456

[cunning geode]

aaah

thn

SELECT password FROM users WHERE username = 'root' LIMIT 1;