--截取列 magazineid 字段信息为1234521214512,45675856 截取后的效果 1234521214512
select
exper.*, docpr.*
from
ZTESPT_EXPERIENCESUBSCIBE exper
left join
ZTESPT_VIEW_DOC_PRODUCT docpr
on substr(exper.magazineid,0,instr(exper.magazineid,',') - 1) = docpr.docid
where subscriberid = 30;
数据库截取字符串
最新推荐文章于 2024-07-12 16:34:24 发布