PASSWORD() function problem

[Manisha Sathe]

Hi,

I inserted one record thr PHPMyAdmin -  mem_pass field of member table set to xyz using
function 'PASSWORD'

Then trying to select the same - select * from member where mem_pass = PASSWORD('xyz') -
then it is not getting selected

I do not know why I am not getting the result. please help me. what's going wrong ? 

Thanks in advance
Manisha