ALTER VIEW [dbo].[V_CF_Pub]
AS
SELECT
FID, case when FType='photo' then replace(convert(varchar(300),FContent),'../../upload/','/img/FileBase/upload/') else FContent end as
FContent, FTIME, , FType
FROM CF_Pub
当字段FContent里面有../../upload/这样的路径就换成/img/FileBase/upload/
