批量修改将topic_id
的2267替换成0
UPDATE
`WarningSendMail`
AS
alias_1
INNER
JOIN
(
SELECT
*
FROM
`WarningSendMail`
WHERE
flag=1
AND
topic_id
LIKE
"%2267%"
)
AS
alias_2
SET
alias_1.topic_id =
REPLACE
(alias_1.topic_id,
'2267'
,
'0'
)
WHERE
alias_1.id = alias_2.id