mysql替换所有字符串

REPLACE(str, from_str, to_str)

UPDATE users SET email = REPLACE(email, 'example.com', 'newexample.com');

START TRANSACTION;
UPDATE users SET email = REPLACE(email, 'example.com', 'newexample.com');
COMMIT;

-- 分批处理数据的示例
DELIMITER //
CREATE PROCEDURE BatchReplaceEmail()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE v_email VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT email FROM users WHERE email LIKE '%example.com%';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO v_email;
        IF done THEN
            LEAVE read_loop;
        END IF;
        UPDATE users SET email = REPLACE(v_email, 'example.com', 'newexample.com') WHERE email = v_email;
    END LOOP;

    CLOSE cur;
END //
DELIMITER ;

CALL BatchReplaceEmail();