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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
