Select based on a password

[awingnut]

I have a table that contains passwords for users. When using mysql_auth, it works fine. However, when I try the following:

select * from mytable where pwd=encrypt('correctpassword');

All I get is the empty set. Is there some trick or restriction for issuing a query using a password field? TIA.

 

[awingnut]

Never mind. I found the problem. It was a config problem not a query problem. Sorry.