SQL syntax for the result set of MySQL under Select as the Where condition of the update

UPDATE ' Warningsendmail ' as Alias_1 INNER JOIN (SELECT * from ' Warningsendmail ' WHERE flag=1 and topic_id like "%2267%") A S alias_2 SET alias_1.topic_id = REPLACE (alias_1.topic_id, ' |2267 ', ') WHERE alias_1.id = Alias_2.idupdate Warningsendmail set topic_id= REPLACE (topic_id, ' |2267 ', ') where ID in (SELECT ID from warningsendmail where flag=1 and T opic_id like "%2267%");

　　

SQL syntax for the result set of MySQL under Select as the Where condition of the update