select * from test where instr(aa,'1',1,1)>0
select * from test where instr(aa,'2',1,1)>0
select * from test where instr(aa,'3',1,1)>0
select * from test where instr(aa,'4',1,1)>0
select * from test where instr(aa,'2',1,1)>0
select * from test where instr(aa,'3',1,1)>0
select * from test where instr(aa,'4',1,1)>0
select t.* from test t where instr(content,',df') >0 and substr(content,length(content) -2,3) = ',df' union
select t.* from test t where instr(content,'df,') >0 and substr(content,1,3) = 'df,'提取的就是包含“df”的数据!