-- like進(jìn)行右模糊查詢
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進(jìn)行右模糊查詢
select *??from AI_OC_ORDER order0_
where 1=1 and instr(order0_.ORDER_ID,'201709200000000005')=1 order by order0_.CREATE_TIME desc;
-- like進(jìn)行全模糊查詢
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進(jìn)行全模糊查詢
select *??from AI_OC_ORDER order0_
where 1=1 and instr(order0_.ORDER_ID,'201709200000000005')>0 order by order0_.CREATE_TIME desc;
