求一sql语句，谢谢大家，在线等

Question

有以下数据，比如需要将里面的CS-0005-07修改成CS-0006-07，请问我该怎么做？select path from orderfile;'//order//CS-0004-07//2007-02-13//wsafsdaf.pdf'
'//order//CS-0004-07//2007-02-13//dfsgfds.pdf'
'//order//CS-0005-07//2007-02-02//wersda.pdf'
'//order//CS-0005-07//2007-02-02//sdfgdfsg.pdf'
'//order//CS-0014-07//2007-02-06//wesdfa.pdf'
'//order//CS-0014-07//2007-02-06//sdfgsdfg.pdf'
'//order//CS-0027-07//2007-02-14//ertsdfg.pdf'

Answer 1

已经解决，呵呵update orderdetail
set pdfpath=REPLACE(pdfpath,'CS-0014-07','CS-0020-07') WHERE pdfpath LIKE '%CS-0014-07%';