SELECT REPLACE('Hello, World!', 'Hello', 'Hi');
輸出結果為:Hi, World!
UPDATE table_name
SET column_name = REPLACE(column_name, 'old_value', 'new_value');
SELECT REPLACE('1,2,3,4,5', ',', '');
輸出結果為:12345
SELECT REPLACE('Hello World', ' ', '_');
輸出結果為:Hello_World