title: JPA Repository Query Containing Ignore Case
body: <p>I'm writing a select query using Spring JPA. I'm passing in parameters to compare to an entry in the database. Where I'm running into problems (doesn't compile) is when I try combining UPPER() with the contains (%value%). E.g. %UPPER(value)%</p>
  
  <pre><code>where ... AND (UPPER(l.name1) LIKE %UPPER(:search1)% OR UPPER(l.name2) LIKE %UPPER(:search2)% OR UPPER(l.name3) LIKE %UPPER(:search3)%
  </code></pre>
  
  <p>search1, search2, and search3 are parameters being passed in from my service implementation. Is there a different way of getting this logic of contains ignore case in the query? Or am I missing something small? I've tried finding examples but couldn't find any that relate directly to this situation.</p>
  
  <p>Thank you in advance for the help!</p>