From: Date: October 15 2003 5:05pm
Subject: Re: PASSWORD() function problem
List-Archive: http://lists.mysql.com/mysql/151673
Message-Id: <p06002029bbb31298a05b@[192.168.1.34]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

At 17:26 +0800 10/15/03, Manisha Sathe wrote:
>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

Please consider using something other than PASSWORD(), as noted in the
description for that function at:

http://www.mysql.com/doc/en/Miscellaneous_functions.html

PASSWORD() should not be used for your own applications.

-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/