topr8 - 10:59 am on Oct 20, 2010 (gmt 0)
in which case try something like this.
DECLARE myvariable VARCHAR(100); -- whatever the notes field is
SET myvariable = (SELECT notes FROM temp_users WHERE id = 1);
UPDATE temp_users SET notes = myvariable WHERE id = 2;
is this a one off thing? or something you'll need to do often?