我有个表(Book),其中有个Book_Kind(varchar类型) 字段,Book_Kind 字段中的记录如下 --------------------------------------------------------------------------------- update Book set Book_Kind=replace(Book_Kind,'黑社会','')
update Book Set Book_Kind=replace(Book_Kind, '黑社会', '') from Book
---------------------------------------------------------------------------------
update Book set Book_Kind=replace(Book_Kind,'黑社会','')