title: Rewriting multiple LIKEs in SQL
body: <p>In SQL I can rewrite multiple equivalencies like this:</p>
  
  <pre><code>SELECT * FROM table WHERE (name = "a" or name = "b")
  </code></pre>
  
  <p>to:</p>
  
  <pre><code>SELECT * FROM table WHERE name in ("a", "b")
  </code></pre>
  
  <p>Is there a way to do the same with a <code>%LIKE%</code> statement? For example:</p>
  
  <pre><code>SELECT * FROM table WHERE (name like "a%" or name like "b%")
  </code></pre>
  
  <p>Something like:</p>
  
  <pre><code>SELECT * FROM table WHERE name like ("a%", "b%")
  </code></pre>