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

[Hack]

Maybe something like

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