title: In SQL how to check if a string contains a substring in(case insensitive)?
body: <pre><code>SELECT * FROM products WHERE name LIKE '%a%'
  </code></pre>
  
  <p>This works fine when case sensitive, but how to search case insensitively?</p>
  
  <p>Thx ahead</p>