Просмотр поста

FanLoko,

UPDATE `users` as `t1`
SET `t1`.`city` = 68
WHERE `t1`.`id` IN(
    SELECT `id`
    FROM
    ( 
        SELECT `t2`.`id`
        FROM `users` as `t2` 
        WHERE `t2`.`city` = 67
    ) as `ids`
)