How can I use regular expression in HQL

ken.carlino · **Joined:** Sun Oct 15, 2006 11:20 pm **Posts:** 13

I am using Hibernate with MySQL.

From MySQL documentation, it supports regular expression:
http://dev.mysql.com/doc/refman/5.0/en/regexp.html

My question is how can I use regular expression in HQL?
Or do I have to use Native SQL for query if I need to use regular expression.

Thank you.

pib · **Joined:** Tue Oct 17, 2006 9:53 pm **Posts:** 3

If you don't mind editing a few Hibernate source files and rebuilding the Hibernate jar file, you can add support for MySQL's rlike operator (the regular expression operator) fairly easily. See my description of how to do this at:

http://wordhoard.northwestern.edu/userman/hibernatechanges.html

I have used these changes with only minor modifications since the first releases of Hibernate based upon ANTLR. The changes work fine (for me, anyway) in Hibernate 320 ga.