SET @update_id := null; UPDATE users SET name = 'value', id = (SELECT @update_id := id) WHERE name = 'blah' LIMIT 1; SELECT @update_id;