mysql用法:
select * from user where FIND_IN_SET('4',type);
查询字段(strlist)中包含(str)的结果,返回结果为null或记录
oracle用法:
select * from user where instr(','||type||',',',4,')<>0;
<>0即为存在,返回记录
mysql用法:
select * from user where FIND_IN_SET('4',type);
查询字段(strlist)中包含(str)的结果,返回结果为null或记录
oracle用法:
select * from user where instr(','||type||',',',4,')<>0;
<>0即为存在,返回记录
转载于:https://www.cnblogs.com/justinj/p/10607480.html