替换字段数据值

UPDATE `A`
SET 
    `B` = REPLACE(TRIM(`formulas`), '+试用期', ''),
    `C` = REPLACE(TRIM(`descriptions`), '+试用期', '')
WHERE 
    `B` LIKE '%+试用期%' OR 
    `C` LIKE '%+试用期%';