Hibernate, find substring of an objects field variable

Question

Is it possible to make a hibernate search query to find substrings of a class field varibles. For example:

public class User {

private String username = "asoftdrink";

}

and make a hibernate query to find all objects of class User which cointains the substring "soft" in their variable username.

takteek · Accepted Answer · 2015-10-14 02:35:07Z

1

criteria.add(Restrictions.like("username", "soft", MatchMode.ANYWHERE));

This is equivalent to

where username like '%soft%'

in SQL. Keep in mind, though, this won't be very efficient since the database can't use an index to execute the query.

answered Oct 14, 2015 at 2:35

takteek

7,1504 gold badges41 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you, I'll try this out. Are there some more efficient ways?