Mysql where like exact number?
<p>I've multi select tree categories table </p>

<pre><code>-- id | title  | parentids
-- 1  | black  | 22
-- 2  | white  | 1,3
-- 22 | red    | 1,2
</code></pre>

<p>Query :</p>

<pre><code>SELECT * FORM table WHERE parentids LIKE '%2%' 
</code></pre>

<p><strong>Return :</strong> <strong>black</strong> and <strong>red</strong> </p>

<p><strong>My goal :</strong> since parentids grouped array i need it to return only <strong>red</strong> </p>

<p>any idea is very much appreciated </p>