Using Criteria to query datarecords which onclude wildcards

wuz · **Joined:** Tue Mar 09, 2010 10:57 am **Posts:** 2

Hello,

I can query data when the search pattern is supposed to hold the wildcard with the like-operator like this:

Code:

criteria.createCriteria("mycollectionproperty").add(Restrictions.like("mycol", "%"+ queryObject.getMycol() + "%"));

But how can I do it the other way round? Let's say in the database "VPN*" is stored and should match the search-input-string "VPN123"? Furthermore the records in the database can look like this "*VPN" or "VPN*" or "*VPN*" and i have to adjust the query operator accordingly.

Big thx!

sanne.grinovero · **Posted:** Mon Mar 15, 2010 5:33 am

you can't do that on a database; you could look into Hibernate Search to see if fulltext search capabilities is what you need.