Multiple if-else conditions in MySQL

Hi All,

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

Code:

---

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

Code:

---

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

---

Maybe something like

Code:

---

DECLARE @ZoneValue int
SET @ZoneValue = 0

SELECT
        CASE @ZoneValue
                WHEN 0 THEN '(GMT) ' + ZoneName'
                WHEN > 0 THEN '(GMT+' +  CAST(ZoneValue AS varchar(5)) + ') ' + ZoneName
                WHEN < 0 THEN '(GMT' +  CAST(ZoneValue AS varchar(5)) + ') ' + ZoneName
                WHEN 100 THEN 'Select TimeZone'
                ELSE 'Other'
        END

---