title: How to configure Presto searches to be case-insensitive?
body: <p>In my case, Presto connects to a MySQL database which has been configured to be case-insensitive. But any search through Presto seems to be case-sensitive.</p>
  
  <p><strong>Questions:</strong></p>
  
  <p>1) Is there a way to configure Presto searches to be case-<strong>in</strong>sensitive? If not, can something be changed in the Presto-MySQL connector to make the searches case-insensitive?</p>
  
  <p>2) If underlying DB is case-insensitive, shouldn't Presto searches also be case-insensitive? (I presume that Presto only generates the query plan and the actual execution happens on the underlying database)</p>
  
  <p>Example: Consider the below table on MySQL.</p>
  
  <pre><code>name
  ____
  adam
  
  Alan
  
  
  select * from table where name like '%a%'
  // returns adam, Alan on MySQL
  // returns only adam on Presto
  
  select * from table where name = 'Adam'
  // returns adam on MySQL
  // returns NIL on Presto
  </code></pre>