ORACLE模糊查询按照关键字出现的位置排序
select f.id, f.content, instr(f.content,‘2’,1) as position, f.type, TO_CHAR(f.create_date,‘yyyy-MM-dd HH24:mi:ss’) create_date, f.RWfrom (select t.id, t.content, t.type, t.create_date, rownum RWfrom DDM_IM_DISABLE_THESAURUS t where t.content like ‘%2%’
原创
2020-12-18 16:53:13 ·
301 阅读 ·
1 评论