Pleasse Help MSQYL decode

[razmon]

Hi. I'm using the mysql encode to encode data using the command
set column name= ENCODE('variable name','key') where id=??
key being a password-type string

It encodes the string text, but I can decode it. I've looked in the manual and am probably missing something.

How can I decode the encoded string in the column.
what would be the correct syntax for decoding text string in column?

Can sombody please help me here

Thanx

Ray

[malbera]

can you show us what have you tried?

[razmon]

Thanks for your reply

the password for this excersise is 1234

The column or fieldname is number

$var="A Number";

ie update tablename set=number=encode('$var','1234') where id=$id;

that works ok

when I go to decode

I'm using
select * from tablename where name="$name"
select decode(encode(number,'1234'), '1234');

I hope this helps you - please any help would be greatly appreciated
Regards
Ray

[mrmufin]

Encode $str using the password $pw:

$pw = "1234";
"UPDATE table SET val=ENCODE($str, $pw) WHERE id='some id'";

Select the decoded value:

$pw = "1234";
"SELECT DECODE(val, $pw) FROM table WHERE id='some_id'";

Not too tough, eh?

[razmon]

Thanks mrmuffin

I'll give that a try. It's been driving me crazy to date.

Will let you know how I get on

Thanks again

Regards
Ray