title: Hibernate: Is it possible to use Like and In together in Named Query?
body: <p>My named query is quite long because of using Like with OR as object tree is quite big. Can we use Like and In together in Named Query:</p>
  
  <pre><code>#Mysql
  @NamedQuery(name="getDhahush", query="SELECT d.pid FROM Dhahush d WHERE lower(d.person.telephon.mobile.mobno) LIKE lower('78129%') OR lower(d.person.telephon.mobile.mobno) LIKE lower('8129%') OR lower(d.person.telephon.mobile.mobno) LIKE lower('5159%')")
  </code></pre>
  
  <p>The underlying database is MySQL.</p>