java - How to use HQL to filter out entities with collection attributes

Question

For example, the entity User contains the nicknames attribute of Set<String>.
There are n User objects, and one of the User's nicknames collection contains "admin".
How to write HQL to return the User entity whose nicknames collection contains "admin"?

Answer 1

• Join

• Member of