Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Using MySQL REGEXP or RLIKE operations in HQL queries?

 
Philippe Desrosiers
Ranch Hand
Posts: 138
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is a very old JIRA request to use the MySQL dialect-specific RLIKE and REGEXP operators in HQL (see here). According to this, it was implemented, but I can't find any references anywhere on how exactly to use it.

Can anyone provide an HQL example using the MySQL REGEXP operator in the WHERE clause?
 
Philippe Desrosiers
Ranch Hand
Posts: 138
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
BUMP!

Almost a year later, but still bumping. Has anyone figured out how to use rlike in HQL queries in Hibernate3?
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!