I had a table with a bunch of users and one of the users is a demo
user and I wanted to copy the login token from my row to the demo user. This is how I managed to do that.
UPDATE users SET token = (SELECT token FROM users u WHERE u.id = 1) WHERE id = 2;
This will update the token
column for the user with the id 2
with the value from the user with the id 1
.