mysl的批量替换语句

将cdb_pms表subject字段中的Welcom to替换成 欢迎光临

UPDATE `destoon_news`
SET `linkurl` = REPLACE(`linkurl`, ''http://localhost:8002/'', ''/'')
WHERE INSTR(`linkurl`,''http://localhost:8002/'') > 0