title: how to use ignore case in spring JPA @query?
body: <p>I have query as below:</p>
  
  <pre><code>@Query("SELECT b FROM Brand b WHERE b.name1 LIKE %:name1% or b.name2 like %:name2%")
  List&lt;Brand&gt; findSome(@Param("name1") String name1, @Param("name2") String name2);
  </code></pre>
  
  <p>I want to ignore case so that I tried to modified it</p>
  
  <pre><code>@Query("SELECT b FROM Brand b WHERE lower(b.name1) LIKE lower(%:name1%) or lower(b.name2) like lower(%:name2%)")
  </code></pre>
  
  <p>But this looks like don't work, how can I do?</p>