sql語句

select * from dbo.BH_RecordValue where rvalue like '%media/%' order by InTime desc

 793  南甯賓陽鑫鑫幼稚園

update 表名 set 字段名 = replace(字段名(varchar,字段名),'原關鍵字','新關鍵字') where 條件

select * from BH_GardenInfo where iOrdinal=458

select * from dbo.BH_RecordValue where rvalue like '%media/%' and GID=1138 order by InTime desc

--update BH_RecordValue set RValue = replace(cast(RValue as varchar(8000)),'media','江西省人民政府直屬機關第二保育院') where GID=458 and rvalue like '%media/%'