SQL Replace function in HQL

willbarker · **Joined:** Mon Feb 04, 2008 7:42 am **Posts:** 7

Hibernate version: 3.2.5

I am trying to convert a legacy SQL bulk update statement into HQL. The SQL is:

UPDATE table t1
SET t1.desc =
(
SELECT REPLACE(t2.desc,'<body>','')
FROM table t2
WHERE t2.desc = t1.desc
)
WHERE t1.desc LIKE '%<body>%'

Could someone please help, I particularly need help converting the "REPLACE" function with a HQL equivalent. I have searched through the docs and google and was unable to find one.

Cheers

cbredesen · **Posted:** Mon Mar 03, 2008 4:17 pm

Those functions should pass straight through to the underlying database AFIAK. What error are you getting when you run this?