title: Alternative solution for multiple LIKE
body: <p>I'm trying to make multiple like in the clause like this code but I need to shorten it because I have to repeat this code for several different conditions to create different tables. I have tried all of the solutions from <a href="https://stackoverflow.com/questions/12957993/how-to-use-sql-like-condition-with-multiple-values-in-postgresql">here</a> but somehow none of this works for me. I have also tried <code>LIKE '[40101,40102,40104]%'</code> and  <code>LIKE '[40101-40102-40104]%'</code> but it did not work too. What should I do?</p>
  <pre><code>SELECT * 
   from table 
   WHERE column LIKE '40101%' 
      OR column LIKE '40102%' 
      OR column LIKE '40105%'
  </code></pre>