需將欄位中特定字串批量替換(如 upload → uploads),MySQL REPLACE() 函數配合 UPDATE 單條語句即可完成,無需程式迴圈。本文提供標準語法、實戰範例與執行前後對比。
UPDATE table_name
SET column_name = REPLACE(column_name, '搜尋字串', '替換字串')
WHERE 條件;
場景:upload_img 表 img_path 欄位含 upload/xxx.jpg,需改為 uploads/xxx.jpg
UPDATE `upload_img`
SET `img_path` = REPLACE(`img_path`, 'upload', 'uploads')
WHERE id IN (1,2,3,4);


REPLACE('abc', 'a', 'x') → 'xbc'REPLACE INTO tbl (id, name) VALUES (1, 'aa'), (2, 'bb');
REPLACE() 區分大小寫;需不區分大小寫可用 LOWER() 配合WHERE id BETWEEN ... 避免長鎖表SELECT ... REPLACE(...) 預覽結果,確認無誤再 UPDATE