mysql查找替换语句

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

-- 分批次更新
UPDATE users
SET email = REPLACE(email, 'example.com', 'newexample.com')
WHERE id BETWEEN 1 AND 1000;

-- 使用临时表辅助更新
CREATE TEMPORARY TABLE temp_users AS
SELECT id, REPLACE(email, 'example.com', 'newexample.com') AS new_email
FROM users;

UPDATE users
SET email = temp_users.new_email
FROM temp_users
WHERE users.id = temp_users.id;

-- 备份数据
CREATE TABLE users_backup AS SELECT * FROM users;

-- 执行更新
UPDATE users
SET email = REPLACE(email, 'example.com', 'newexample.com')
WHERE email LIKE '%example.com%';

-- 检查字符集
SHOW CREATE TABLE users;

-- 修改字符集
ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;