Reg. HQL query

naga.reddy · **Joined:** Wed Oct 11, 2006 2:46 am **Posts:** 3

Hi,
I am new to Hibernate.
I want all users'names not starting with "Mu%". This is my code.

Query q = session.createQuery("from Test u where u.name like \"Mu%\" ");
List result = q.list();

The above query is retrieving all rows from the table.
Please let me know whats wrong in the above query and also let me know correct one.

- Naga

asic · **Joined:** Wed Aug 31, 2005 3:54 am **Posts:** 45

Try :
Query q = session.createQuery("from Test u where u.name not like 'Mu%' ");
List result = q.list();

batmat · **Posted:** Wed Jan 03, 2007 9:32 am

Please use the code tags...

You can also try with the Criteria API:

Code:

Query q = session.createCriteria(this.getClass()).add(Restrictions.like("name", "Mu", MatchMode.START));
List result = q.list(); 

asic · **Joined:** Wed Aug 31, 2005 3:54 am **Posts:** 45

Do it work ?

Don't forget to rate