MySQL Password Encryption

Hi, I was wondering if I could get some MySQL help for the PHP file I'm writing. I'm using the password command to encrypt my passwords in MySQL. Here is a simple line: mysql> insert into fc_Customer (User_Password) values(password("abcd")); Query OK, 1 row affected (0.00 sec) However, when I try to select the line by searching on the password here is the response: mysql> select * from fc_Customer where User_Password=password("abcd"); Empty set (0.00 sec) I can view see that the record was added and that the password was encrypted, but I can't compare it or select it using password function. Can someone please help. Thanks!!! Doug Coning