Hi,

I am trying to execute an sql statement with a regular expression in the where clause. Is there a way, to use regex with hibernate ?

Thanks.

Did you try?

Well I have a sql statement type "mySql", for example :
SELECT * FROM sam_term WHERE name REGEXP '1$'

I know the application should work with at least SQLServer and MySql...
but I cannot use 'regexp' the same way with SQLServer, I have to change the sql statement with using 'like'.

So I was wondering if there would be a way to use a very generic sql statement independant of the database and then use maybe a hibernate special binding to reflect my regular expression search...

Thanks again.