WHERE text LIKE '%司白画%' OR text LIKE '%司白畫%'
OR title LIKE '%司白画%' OR title LIKE '%司白畫%';
-- 替换评论内容
UPDATE typecho_comments
SET text = REPLACE(REPLACE(text, '司白画', 'Sibaihua'), '司白畫', 'Sibaihua'),
WHERE text LIKE '%司白画%' OR text LIKE '%司白畫%'
OR author LIKE '%司白画%' OR author LIKE '%司白畫%';
-- 替换自定义字段
UPDATE typecho_fields
SET str_value = REPLACE(REPLACE(str_value, '司白画', 'Sibaihua'), '司白畫', 'Sibaihua')
WHERE str_value LIKE '%司白画%' OR str_value LIKE '%司白畫%';
-- 替换选项表(可能包含相关设置)
UPDATE typecho_options
SET value = REPLACE(REPLACE(value, '司白画', 'Sibaihua'), '司白畫', 'Sibaihua')
WHERE value LIKE '%司白画%' OR value LIKE '%司白畫%';