Posted by vncntj on 06/12/06 01:37

I'm trying to get the venue in the 'List' column when in contains a
value. But if the venue Is Null then place the event in the 'List'

SELECT
CASE
WHEN event Is Null THEN venue
Else
event
End as 'List'
,DATE_FORMAT(fld_date, '%M') as Monthly
>From na_statistics

• Next in forum: Adding BS to paths
• Prev in forum: Re: strings and conditionals..
• Thread view: MySQL Select Case

[Reply to this message]