— like进行右模糊查询
select count(1) as col_0_0_ from AI_OC_ORDER order0_
where 1=1 and order0_.ORDER_ID like ‘201709200000000005%’ order by order0_.CREATE_TIME desc;
–instr代替like进行右模糊查询
select * from AI_OC_ORDER order0_
where 1=1 and instr(order0_.ORDER_ID,’201709200000000005′)=1 order by order0_.CREATE_TIME desc;
— like进行全模糊查询
select count(1) as col_0_0_ from AI_OC_ORDER order0_
where 1=1 and order0_.ORDER_ID like ‘%201709200000000005%’ order by order0_.CREATE_TIME desc;
–instr代替like进行全模糊查询
select * from AI_OC_ORDER order0_
where 1=1 and instr(order0_.ORDER_ID,’201709200000000005′)>0 order by order0_.CREATE_TIME desc;