That's why you hash the password with an SQL built-in hash function. For security! But the password is still in plaintext inside the query so you can retrieve

That's why you hash the password with an SQL built-in hash function. For security! But the password is still in plaintext inside the query so you can retrieve it from the logs for... security? (I joke, but 20 years younger me, self-teaching php and security etc? Who knows what she'd think of this)