Sebastián Ariel Cortés found this on SO: https://stackoverflow.com/questions/592147/hql-equivalent-of-sql-contains .

`contains` is not part of HQL so if you want to use it, you can use a native query.