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/%'