How to compare php password with sql that was inserted with PASSWORD

I enter the password with the PASSWORD argument in my example query.

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, PASSWORD(value2), value3, ...);

I want to know if I have the value of an input to know if it is the same, I already have the password in a $ _SESSION saved. I want to know how to transform the input password in this type of encryption and compare.