title: How to search from comma separated string in comma separated column mysql
body: <p>I am working on a project where I have to code for job filters.
  In this when I filters for salaries it sends salary id's in array like: </p>
  
  <pre><code>job_salary = array(
                [0]=&gt;3,
                [1]=&gt;4,
                [2]=&gt;5,
                [3]=&gt;6,
                [4]=&gt;7,
                [5]=&gt;8  
                )
  </code></pre>
  
  <p>and job in my jobs table contains multiple salaries using comma string.</p>
  
  <pre><code>id  salary_ids 
   1    2,4,6
   2    1,3,5
   3    4,5
   4    9,1
  </code></pre>
  
  <p>So if i search for value 3, and 5 in array form like</p>
  
  <pre><code>job_salary = array(
                [0]=&gt;3,
                [1]=&gt;5
                );
  </code></pre>
  
  <p>It should return me the second and third row because these rows contain value 3 and 5.</p>