Re: mysql DECODE question

SELECT DECODE(ENCODE('password', 'sec'), SUBSTRING("secret",1,3)); if you put quotes around substring function, mysql considere it as a string, so I think you shouldn't. After, are you sure that the correct table field name is the weirdthing encoded by this function : ENCODE('password', 'sec') ??? if so, show us, the script that allow you to record the password ? ----- Original Message ----- From: "Donahue Ben" <fun23_us@yahoo.com> To: <php-general@lists.php.net> Sent: Monday, November 11, 2002 11:13 AM Subject: [PHP] mysql DECODE question > SELECT DECODE(ENCODE('password', 'sec'), 'sec') -> > password > > When I try: > SELECT DECODE(ENCODE('password', 'sec'), > 'SUBSTRING("secret",1,3)'); or without quotes around > SUBSTRING function > > This does not produce the same output, i am not sure > what the problem is. > > Ben > > __________________________________________________ > Do you Yahoo!? > U2 on LAUNCH - Exclusive greatest hits videos > http://launch.yahoo.com/u2 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > >