Hibernate as a request for an escape character

Question

I am using the mysql database. I got saved data for specific columns with the value a\"a . I used the following query to select, but this failed:

 select * from table_name where coloum_name like "%a\"%"; 

I spend several hours finding a query for a selection, and the following works:

 select * from table_name where coloum_name like "%a\\\\\\\\""%"; 

I use hibernate in my application, so I used:

 criteria.add(Restrictions.ilike("coloum_name","%a\\\\\\\\""%")); 

but it does not work. Any possible selection by criteria

Answer 1

Check this. Hope this helps you. http://levanhuy.wordpress.com/2009/02/19/providing-an-escape-sequence-for-criteria-queries/