Hibernate regex query

Question

I want to achieve the effect of the following query in Hibernate, but I cannot find a way to do this.

select e.TITLE from EVENTS e where e.TITLE REGEXP 'fri|pro'; 

Can anyone help?

Answer 1

Hibernate QL does not support regular expressions (and some engines have very low support for regular expressions). You can convert your request to

 select e.TITLE from EVENTS e where (e.TITLE = 'fri' OR e.TITLE = 'pro'); 

or

 select e.TITLE from EVENTS e where e.TITLE in ('fri','pro'); 

But for real support for regular expressions you will have to write your own SQL (if your database supports regular expressions at all)