How to escape wildcard characters in "like" clause in HQL?
- by Pablo Cabrera
How can I escape the wildcard characters in a like clause?
E.g.:
select foo from Foo as foo where foo.bar like '%' || :filter ||'%'
query.setParameter("filter", "%");
query.list();
// I'd expect to get the foo's containing the '%' in bar, not all of them!
Any ideas?