public List<Email> findByEmail(String emailPattern) {
StringBuffer hql = new StringBuffer();
hql.append("select obj from Email obj.emailForm REGEXP :email");
Query query = this.session.createQuery(hql.toString());
query.setString("email", emailPattern);
return (List<Email>) query.list();
}

What's your problem, write in detail is it REGEXP, or else,

you can change the query like these,

select obj from Email obj.emailForm = :email

you know i want to use in the follow Native SQL

select * from tblUser where name REGEXP '^A{1,3}$';

like this, but i don't know how it was equal to HQL ?