title: using LOWER with IN condition
body: <p>assume I have a table named <code>comodity_group</code> and the structure looks like:</p>
  
  <pre><code>+----------+-------+
  | group_id | name  |
  +----------+-------+
  | 1        | Data1 |
  +----------+-------+
  | 2        | Data2 |
  +----------+-------+
  | 3        | data3 |
  +----------+-------+
  </code></pre>
  
  <p>and I have the following query</p>
  
  <pre><code>SELECT * FROM comodity_group WHERE name IN('data1','data2','data3')
  </code></pre>
  
  <p>the query return 0 result, because condition is all in lowercase <strong>(note that the condition is also dynamic, meaning it can be Data1 or daTa1, etc)</strong></p>
  
  <p>so I want to make both condition and field name in lowercase, in other word case insensitive.</p>