title: JPQL Like Case Insensitive
body: <p>I want to search data in User table by name case insensitive.</p>
  
  <pre><code>@Repository
  public interface UserRepository extends JpaRepository&lt;User, Long&gt; {
  
    @Query("select u from User u where lower(u.name) like %lower(?1)%")
    public List&lt;User&gt; findByNameFree(String name);
  
  }
  </code></pre>
  
  <p>I got an error: <em>unexpected token: %</em>. Where should I place '%'?</p>