title: mysql query with WHERE IF and FIND_IN_SET() function
body: <p>I have been using the following query:</p>
  
  <pre><code> "SELECT * FROM mytable WHERE IF(FIND_IN_SET(column1,'$searchString') &gt; 0,1,0) 
  + IF(FIND_IN_SET(column2, '$searchString') &gt; 0, 1, 0) 
  + IF(FIND_IN_SET(column3, '$searchString') &gt; 0, 1, 0)+ 
  IF(FIND_IN_SET(column4, '$searchString') &gt; 0, 1, 0) &gt; 0";
  </code></pre>
  
  <p>So (in case) after 4 successful matches, does the query becomes the following??:</p>
  
  <pre><code>"SELECT * FROM mytable WHERE 1+1+1+1 &gt; 0";
  </code></pre>
  
  <p>Please ensure me whether my assumption is right. thanks in advance.</p>