oracle实现like多关键字查询:
查询脚本:
select F_CREATORUSERID from atabletemplate tt where 1 = 1 and REGEXP_LIKE(tt.F_CREATORUSERID, '18C21-03050|6005119')
执行结果:
oracle实现like多关键字查询:
查询脚本:
select F_CREATORUSERID from atabletemplate tt where 1 = 1 and REGEXP_LIKE(tt.F_CREATORUSERID, '18C21-03050|6005119')
执行结果:
转载于:https://www.cnblogs.com/yx007/p/6377754.html