hi,

this is probably straightforward question: i want to update my table by performing a function on name_ID field and saving it as ID_encryp field, namely by encrypting it; but i'm also interested in the bigger question of how to do a function on a field and save it in another field in mysql.

the next question is where to start to get the SQL code to go through the table and perform the function on each row, saving the result in the ID_encrypt field.

sorry, i know this is probably pretty basic.

all help appreciated.

mike

will update all rows

thanks r937. it was just what i needed . . .