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
Re: Multiple if-else conditions in MySQL
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