MySQL Use an In Clause With a Comma Delimited Column
col IN (1,2,34)        -- A
col IN (&quot;1,2,34&quot;)      -- B
col IN (&quot;1&quot;,&quot;2&quot;,&quot;34&quot;)  -- C

Binding tends to produce B, but...
A and C have 3 choices, B has only one choice (a 6-character string)
Both A and C work if col is INT; C works if col is VARCHAR.
A, B, and C, may be able to use an INDEX.
FIND_IN_SET(col, &quot;1,2,34&quot;)  -- D

Find_in_set has these characteristics:

Easy to 'bind'
Won't use an INDEX
Works with strings or numbers.