Hi,
If I remember, ENCODE() is reversible using DECODE() or something similar.
I might be wrong, just check the manual!!!
Thanks
Emery
----- Original Message -----
From: "Nitin" <[EMAIL PROTECTED]>
To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 16:13
Subject: Re: PASSWORD() function problem
> all encryption functions are one way only
>
> Nitin
>
> ----- Original Message -----
> From: "Manisha Sathe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, October 16, 2003 6:46 PM
> 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]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
