Hi,

In my database I have a table with a "name" column and one row which contains the value "test"

If I use this criterion :

criteria.add(Expression.like("name", "%test%"))

the query works very well and returns the row.

but if I do this :
criteria.add(Expression.like("name", "%te%"))

nothing is returned!

I thought that by doing this "%te%" the row containing "test" would be return.

What query should I do if I want thto retrieve the row "test" by entering "te" or "t" or "tes"?

thanks

Try using MatchMode.ANYWHERE in the InExpression constructor or Restrictions.in() method. Also, if data in your database is case sensitive, use Restrictions.ilike().

Do not forget to post a reply if this answers your question.

==============================

Shreenath Sreenivas
Senior Software Engineer (TL)
Ocimum Biosolutions