title: Case sensitive and insensitive like in SQLite
body: <p>In SQLite it is possible to change the case sensitive behaviour of 'LIKE' by using the commands:</p>
  
  <pre><code>PRAGMA case_sensitive_like=ON;
  PRAGMA case_sensitive_like=OFF;
  </code></pre>
  
  <p>However in my situation I would like to execute a query, part of which is case sensitive and part of which isn't. For example:</p>
  
  <pre><code>SELECT * FROM mytable
  WHERE caseSensitiveField like 'test%'
  AND caseInsensitiveField like 'g2%'
  </code></pre>
  
  <p>Is this possible?</p>