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

# Koenig (22.06.2017 / 19:37)
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` = 6

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` здесь должны быть все значения в пределах от 60 до 67? 
    ) as `ids`
)