My SQL Password function

[DoD]

As im making a user database with passwords... should i set the function of the field to password?

Is the fact that it changes it completely make muc difference to my scripts? i want to be able to get a result from the database and check the password the user submitted with the one in the database. Will it still be scrambled when its been retrieved?

Or is there a way i can send the password to the database and it check it?

because i dont want to leave it as text in my database...

[dnszero]

Yes. Just use the mysql password() function when you put it in the database and use that function when you query the db, too.

Going in:
INSERT INTO users VALUES ($user, password($pw));

Checking for correct pw later on:
SELECT * FROM users WHERE name=$user AND passwd=password($pw);