mysql\oracle字符串是否包含某个字符串

oracle 

select * from WBHC_CHELIANGKU_LINK where instr(CHEPAI,'京')=0;

instr(字段,检索字符) 判断条件

instr('abc','a') = 1

instr('abc','d') = 0

mysql 

SELECT * FROM `analysis_jing_vehicle_all_datasource` where  find_in_set('字符', chepaihao);

posted @ 2018-12-18 11:17  缘来是妳啊  阅读(30)  评论(0编辑  收藏  举报