PASSWORD() is a one-way function (I was confirming just).
Though, it has worked for you, please consider the advice of Paul in his
previous Email when he recommended you read about PASSWORD() at the URL:
http://www.mysql.com/doc/en/Miscellaneous_functions.html
Thanks
Emery
----- Original Message -----
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 15:16
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase it to 20)
> but one more thing, now if i want to get this password (e.g for option
> forget password), can we retrieve, i believe we can not- just want to
> confirm
>
> manisha
>
> ----- Original Message -----
> From: "Paul DuBois" <[EMAIL PROTECTED]>
> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, October 15, 2003 11:05 PM
> Subject: Re: PASSWORD() function problem
>
>
> > 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/
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
