title: "Merge" IN and LIKE operator in Mysql
body: <p>I've a problem and I'm guessing if there's a better way to achieve my goal. I've this query in Mysql to retrieve some rows:</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE field IN ('V','S','G','B')
  </code></pre>
  
  <p>What I would like to do is to run a query that retrieve the rows where the field has value LIKE those in the IN list. I know that the trivial way is to use this query:</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE field LIKE '%V%' OR field LIKE '%S%' OR
        field LIKE '%G%' OR field LIKE '%B%'
  </code></pre>
  
  <p>What I want to know is there's an operator that do this or at least, if that operator does not exist, a better way to write the query.</p>
  
  <p>Thanks to everyone that will help me.</p>