UPDATE t_user SET end_date = ‘2019-6-10 23:59:59’ WHERE uid IN (
(SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b )
)
步骤:
1、按条件查询出数据将查询结果作为中间表
SELECT uid from t_user WHERE username LIKE ‘wtm05%’
2、再查询一次中间表作为结果集
(SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b)
3、进行更新数据
UPDATE t_user SET end_date = ‘2019-6-10 23:59:59’ WHERE uid IN (
(SELECT uid FROM(
SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b
)
)