For database a column is a comma-separated list, how to put the screening process contains a number of data, such as the field data that contains 3 screening out, cannot use like,

CodePudding user response:

SELECT * FROM TABLES WHERE (PERMISSIONS, '3') & gt; 0;

CodePudding user response:

Missing function instr upstairs?

CodePudding user response:

So, there are 13 this data such as field, it also can filter out with instr words

CodePudding user response:

reference weixin_41134218 reply: 3/f

so, there are 13 this data such as field, which use the instr will filter out

You can put on both sides of the ", "also added to the match in the string