mysql: how to select imploded array value : <p>So I have a column that store imploded array values via <code>,</code> ,  how can I select array value with the following condition:</p>

<p>if column stored values like below: </p>

<pre><code>+-----+------------------------------------------------------------+
| row |                           column                           |
+-----+------------------------------------------------------------+
| 1   | lorem ipsum,lorem ipsum dolor,lorem ipsum dolor sit amet   |
| --  | --                                                         |
| 2   | consectetuer adipiscing,lorem ipsum amet,lorem ipsum dolor |
| --  | --                                                         |
| 3   | lorem ipsum,consectetuer adipiscing,lorem ipsum dolor      |
+-----+------------------------------------------------------------+
</code></pre>

<p>I want to select the rows that has <strong>lorem ipsum</strong> value, I know we can use <code>Like</code> but if use <code>like</code>, it select <strong>lorem ipsum dolor</strong> or <strong>lorem ipsum amet</strong> too!
I try following  query:</p>

<pre><code>select * from table where column like '%lorem ipsum%'

# my expected rows :1,3
# query result :1,2,3
</code></pre>
