aspose file tools*
The moose likes Object Relational Mapping and the fly likes Using MySQL REGEXP or RLIKE operations in HQL queries? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Using MySQL REGEXP or RLIKE operations in HQL queries?" Watch "Using MySQL REGEXP or RLIKE operations in HQL queries?" New topic
Author

Using MySQL REGEXP or RLIKE operations in HQL queries?

Philippe Desrosiers
Ranch Hand

Joined: Mar 29, 2006
Posts: 138
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

Joined: Mar 29, 2006
Posts: 138
BUMP!

Almost a year later, but still bumping. Has anyone figured out how to use rlike in HQL queries in Hibernate3?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using MySQL REGEXP or RLIKE operations in HQL queries?