-- 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;
