how can i update this within a single statement?

laknar · #1 (**permalink**) 03-29-09, 22:45

how to update a table based on multiple single column values.

IF COLUMN1='P' THEN update stats COLUMN2 AS 'W' Else update COLUMN2 AS 'S';

how can i update this within a single statement?

tonkuma · #2 (**permalink**) 03-29-09, 23:37

Quote:

..... based on multiple single column values.

I couldn't understand well this clause.

Quote:

IF COLUMN1='P' THEN update stats COLUMN2 AS 'W' Else update COLUMN2 AS 'S';

This would be the following statement.

Code:

UPDATE .....
   SET column2
       = CASE column1
         WHEN 'P' THEN
              'W'
         ELSE 'S'
         END
 WHERE .....
;

laknar · #3 (**permalink**) 03-30-09, 00:06

many thanks it worked for me.

Internet Services

Web Development

Digital Marketing

Consumer Tech