字段名OCONTENT VARCHAR2(2000)
select ocontent as 选项,replace(ocontent,'<div>','') as 选项1,replace(ocontent,'</div>','') as 选项2 出现以下结果<div>A.很好</div> A.很好</div> <div>A.很好目标要把<div>和</div>都替换掉,得出
A.很好
这个结果,怎么写,立马结贴
select ocontent as 选项,replace(ocontent,'<div>','') as 选项1,replace(ocontent,'</div>','') as 选项2 出现以下结果<div>A.很好</div> A.很好</div> <div>A.很好目标要把<div>和</div>都替换掉,得出
A.很好
这个结果,怎么写,立马结贴
from tb;
REPLACE(REPLACE(OCONTENT, '</div>', ''), '<div>', '') AS 选项3
FROM T;
select replace(replace(ocontent,' <div>',''),' </div>','') as 选项
from tb;
as后面跟数字为什么就不行了?
要加双引号
select replace(replace(ocontent,' <div>',''),' </div>','') as "33"