如何在Mysql中检查数组中的列

Question

Sorry if the topic name is not reasonable.

I have a column in mySql with value (10,11,12), it's a string, like this

And I have an array to check, how can select this row if array contains any one value 10, 11 or 12. For example:

array(3,4,11) - choose
array(5,6,7) - not choose
array(11,8,10) - choose

Thank you!

Answer 1

Here is the query :

SELECT *
FROM your_table
WHERE FIND_IN_SET(10, custom_categories) 
      OR FIND_IN_SET(11, custom_categories) 
      OR FIND_IN_SET(12, custom_categories);

For More Detail : Read