CODEWITHSUNDEEP
javamysqlhibernatehql
user1191027
user1191027

Reputation:

HQL :parameter length

How do I perform substring with a parameter's length?

i.e.

Query query = HibernateUtil.getSessionFactory().getCurrentSession().createQuery("SELECT * from User where substring(name, 1, :name.length()) like :name");

Upvotes: 0

Views: 945

Answers (1)

Aniket Kulkarni
Aniket Kulkarni

Reputation: 12983

In SQL query name.length() would not work, however you can use following

Query query = HibernateUtil.getSessionFactory().getCurrentSession().
              createQuery("SELECT * from User where substring(name, 1, :length) like :name");

query.setParameter("length",name.length());
........
........

Upvotes: 0

Related Questions