subject:"Using CASE for store values"

Re: Using CASE for store values

2004-06-25 Thread SGreen

Fax to: 06/25/2004 05:48 Subject: Using CASE for store values

Using CASE for store values

2004-06-25 Thread ColdFusion Lists

Hi allit's possible to use the CASE clause in MySQL like this:SELECT statusID, Case(statusID = 1, TotalStatus1=TotalStatus1 + 1) Case(statusID = 2, TotalStatus2 = TotalStatus2 +1) It's possible? How to do that? Thanx for your time.Crie seu Yahoo! Mail, agora com 100MB de espaço, anti-spam e antivír