Hello I have a query where I want to filter the ips ending in 2. For that I wrote the NamedQuery as such:

@NamedQuery(name.., query=" ... AND c.ip NOT LIKE. '%2'")

But this doesn’t work even if for c entity ip is a String, but in database it is a inet column. I tried using cast with as string but it says that PSQL doesn’t support data type string. Is there any other way to filter those ips using jpql? Thank you!