Hi

I'm using hibernate.3.2.0.cr2

I want to write a query that looks like this:

session.createQuery( "select * from contact where emailAddress REGEXP :filter )
.setString( "filter", "[^" + getFilter() + "]" );

getFilter() can return 'a' or 'b' ( any character in the alphabet) or '0-9'

any help will be appreciated.

thanks
sophia

REGEXP is not SQL standard (i guess you are using MySQL?), so i think you must use

session.createSQLQuery()