Is this hibernate update query with inline if statement possible. Its giving me error SQLException: user lacks privilege or object not found: IF. The inline if statement is working on mysql

If there any other way to achive this query in HQL


UPDATE yyyEntity as xxxentity SET xxxentity.active = FALSE, xxxentity.xxxStatus = if (xxxentity.endDate < NOW(), 'EXP',(if (xxxentity.startDate >= NOW() and xxxentity.active = TRUE, 'CUR', 'PEND'))) WHERE xxxentity.id = ?1

you can try using case when , that works for me .
http://stackoverflow.com/questions/6117249/how-can-i-use-case-on-this-mysql-query

It worked . Thanks

UPDATE yyyEntity as xxxentity
SET xxxentity.active = FALSE,
xxxentity.licenseStatus =
CASE
WHEN xxxentity.endDate < NOW() THEN 'EXP'
WHEN xxxentity.endDate >= NOW() and xxxentity.active = TRUE THEN 'CUR'
END
WHERE xxxentity.id = ?1

Great. You are the best. :)