Solution:
Use theĀ FIND_IN_SET function:
SELECT t.* FROM YOUR_TABLE t WHERE FIND_IN_SET(3, t.ids) > 0