title: How to speed up LIKE operation in SQL (Postgres preferably)
body: <p>We have a Postgres database which contains 2 millions entries. We have tried using equality search and it works instantly (SELECT * FROM a WHERE b = "asd")</p>
  
  <p>But we would like "LIKE '%asd%'" operation to be fast too. How do we do that?</p>