删除例如29这条数据中后边第二个 "click" 只有一个"click"的不做改动例如第30条
select method from T_TEST where method like '%click%,%';
update T_TEST set method = CONCAT(left(method, LOCATE(')', method)-10), ')') where method like '%click%,%';
删除例如29这条数据中后边第二个 "click" 只有一个"click"的不做改动例如第30条
select method from T_TEST where method like '%click%,%';
update T_TEST set method = CONCAT(left(method, LOCATE(')', method)-10), ')') where method like '%click%,%';