title: Select both uppercase and lowercase from column
body: <p>I was wondering how I could get both uppercase and lowercase  from a sql query.</p>
  
  <p>I've got lets say these values in my database. </p>
  
  <pre><code>John
  Marco
  jason
  nico
  </code></pre>
  
  <p>So I would like to get both John and jason as a result.<br>
  At the moment I am searching with:</p>
  
  <pre><code>$pdo-&gt;prepare("SELECT name FROM users WHERE name LIKE 'J%'");
  </code></pre>
  
  <p>However this only gives me John.</p>