--暈,這樣應就可以了,被我搞復雜了
select * from testTable where regexp_like(modelname,'[^0-9]6cc');

------解决方案--------------------
探讨

SQL code


--暈,這樣應就可以了,被我搞復雜了
select * from testTable where regexp_like(modelname,'[^0-9]6cc');


------解决方案--------------------

SQL code

--是不支持,呵呵,這樣寫
select * from testTable where modelname like '%6cc%'
    and (instr(modelname,'6cc')=1 or (substr(modelname,instr(modelname,'6cc')-1,1) not between '0' and '9'));