postgresql - Like query on TEXT data type field (postgres) in spring JpaRepository -


i have object newsitem in postgres database field body text data type , column contains ids.

i want perform query using jparepository.

select * news.news_item newsitem lower(convert_from(loread(lo_open(newsitem.body::int, x'40000'::int), x'40000'::int),  'utf8')) lower(('%'||'query'||'%'));

^this query in pgadmin returns correct result. how can convert query work in spring jparepository?


-