How to get the value of a column of a certain row from a table?

Question

MySQL

What is the correct way to make a query to the players table
If you want to retrieve the hp value depending on the id value
Example of a table with data

How, for example, to retrieve the hp value if id = 12345 ?

Answer 1

SELECT
    hp
FROM
    players
WHERE
    id = 12345