and add "AS CO" following the END
of the case statement.
-Original Message-
From: Jesse Castleberry [mailto:[EMAIL PROTECTED]
Sent: Friday, November 04, 2005 3:54 PM
To: MySQL List
Subject: SQL Statement Conversion
I'm converting an application from SQL Server to MySQL. I ha
I'm converting an application from SQL Server to MySQL. I have the
following query that I need to convert:
SELECT A.*, CO = CASE CounselorOnly WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END
FROM Activities a ORDER BY Activity
What is the proper syntax for this in MySQL?
Thanks,
Jesse
--
MySQL Genera
