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]