Multiple if-else conditions in MySQL

[eranga262154]

Hi All,

I want to use multiple if-else conditions on the following query.

UPDATE tblTimeZone
SET GMTZoneName = '(GMT+' +  CAST(ZoneValue AS varchar(5)) + ') ' + ZoneName
WHERE ZoneValue > 0

UPDATE tblTimeZone
SET GMTZoneName = '(GMT' +  CAST(ZoneValue AS varchar(5)) + ') ' + ZoneName
WHERE ZoneValue < 0

UPDATE tblTimeZone
SET GMTZoneName = '(GMT) ' + ZoneName
WHERE ZoneValue = 0

UPDATE tblTimeZone
SET GMTZoneName = 'Select TimeZone'
WHERE ZoneValue = 100

Can someone help to convert this into if-else statement.

I tried to use case statement as follows, but messit

SELECT CASE
WHEN ZoneValue > 0 
THEN 
SET GMTZoneName = '(GMT+' +  CAST(ZoneValue AS varchar(5)) + ') ' + ZoneName
ELSE 'Negative'
END GMTZoneName
FROM tblTimeZone