Regex query in Hibernate

Question

I want to achieve the effect of following query in Hibernate, but I'm unable to figure out a way to do this.

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

Can someone help?

Augusto · Accepted Answer · 2011-04-29 12:09:40Z

6

Hibernate QL doesn't support regular expressions (and some engines have a very poor regexes support). You can transform your query to be

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 regex support you'll have to write custom SQL (if your DB does support regexes at all)

answered Apr 29, 2011 at 12:09

Augusto

30.2k6 gold badges66 silver badges98 bronze badges

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

2 Comments

Shwetanka Over a year ago

Thanks, but value in my column will be like this 'fripro' ( are just delimiters). How do I work out this?

mazaneicha Over a year ago

select e.TITLE from EVENTS e where e.TITLE like 'fri%pro' OR e.TITLE like '%fri%' OR e.TITLE like '%pro%' Pick what "like" you like more :-) i.e. which one meets your conditions since they are still unclear.

Collectives™ on Stack Overflow

Regex query in Hibernate

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related