1 PM
> To: Richard Forgo; MySQL Mailing List
> Subject: RE: case expression
>
> Consider the CASE statement to be a function, that can only return
values.
> Aliases would go outside the CASE STATEMENT, as follows:
>
> SELECT
> CASE
> WHEN CHARACTER_LENGTH(system)
h_year,
id
FROM wsh
-Original Message-
From: Richard Forgo [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:44 PM
To: Jon Wagoner; 'MySQL Mailing List'
Subject: RE: case expression
Thanks, that works fine. If I wanted to create an alias for the column,
how woul
e-
> From: Jon Wagoner [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 4:34 PM
> To: Richard Forgo; MySQL Mailing List
> Subject: RE: case expression
>
> Put the other fields after the CASE statement:
>
> SELECT
> CASE
> WHEN CHARACTER_LENGT
Put the other fields after the CASE statement:
SELECT
CASE
WHEN CHARACTER_LENGTH(system) > 65
THEN
CONCAT(LEFT(system, 60), " ...")
ELSE
system
END,
wsh_year,
id
FROM wsh
The CASE statement just returns 1 field.
-Original Message-
From: Richard For
