title: SQL query to match multiple values in a single column
body: <p>This dummy table:</p>
  
  <pre><code>name | lesson_mode
  -------------------
  
  a    | 1,2,3
  b    | 2,3 
  c    | 2
  d    | 3
  </code></pre>
  
  <p>Using this query:</p>
  
  <pre><code>SELECT * FROM `cc_teacher` WHERE lesson_mode IN (2,3)
  </code></pre>
  
  <p>I get</p>
  
  <pre><code>name | lesson_mode
  -------------------
  
  b    | 2,3 
  c    | 2
  d    | 3
  </code></pre>
  
  <p>I am having a problem in search results, my problem is that suppose, in this case we are talking about <code>lesson_mode</code> column, I have written the SQL query like this: </p>
  
  <pre><code>SELECT * FROM `cc_teacher` WHERE lesson_mode IN (2,3) 
  </code></pre>
  
  <p>but I didn't get the row in which have <code>1,2,3</code>, so please help me. Anyone know how to do that?</p>