LIKE restriction from the Hibernate Criteria API

The restriction should use the percent symbol.

Criterion c1 = Restrictions.like("stateName", "Virg%");

Use the enum MatchMode to help you with it:

Criterion c1 = Restrictions.like("stateName", "Virg", MatchMode.START);

Don't use any special character, like *. And if you want a case-insensitive like, use ilike.