How to use FIND_IN_SET in jpa

Question

How can I use find_in_set in jpa?

I need to achieve like this
SQL - select * from teacher where find_in_set("5", deptIds) and id = 101

where deptIds have comma separated ids (I know it's bad idea but legacy.)

To do so I had been tried using Criteria but not found any Restrictions that can fulfill find_in_set.
Note - need possible solution with Criteria and Restrictions

Answer 1

criteriaBuilder.function("find_in_set", Boolean.class,
        criteriaBuilder.literal(s),
        root.get("field"))

Answer 2

Here is an example:

Here is java code snippet.

    list.add(cb.greaterThan(cb.function("FIND_IN_SET", Integer.class,
                                    cb.literal(val.toString()), root.get(attributeName)), 0));

Answer 3

select t from Teacher t where find_in_set("5", t.deptIds) = 0 and t.id = 101