MySQL – How to select rows where value is in array?

Solution:

Use theĀ FIND_IN_SET function:

SELECT t.*
  FROM YOUR_TABLE t
 WHERE FIND_IN_SET(3, t.ids) > 0