sql: how can I find a value and replace it simultaneously?

Question

How can I do something like that

SELECT * WHERE owner = '81',

    owner = NULL

FROM outcome

or

UPDATE outcome SET NULL WHERE owner = '81'

So before request the table contains values 81 but after request corresponding values in NULL.

`UPDATE outcome SET owner = NULL WHERE owner = '81'` does exactly that. Is it something else you're looking for? Like a recordset of updated rows? — dwkd, Feb 26 '15 at 21:10

score 1 · Accepted Answer · edited May 23 '17 at 11:59

1

Assuming outcome is your table name, here is what you need:

UPDATE outcome 
SET owner = NULL 
WHERE owner = '81'

If you also want to select the updated rows see here:

So... in MySQL that part seems a bit tricky.

edited May 23 '17 at 11:59

Community

answered Feb 26 '15 at 21:09

peter.petrov

score 1 · Answer 2 · answered Feb 26 '15 at 21:09

1

Is this what you want?

SELECT * FROM OUTCOME WHERE (OWNER IS NULL OR OWNER='81')

UPDATE outcome SET owner=NULL 
WHERE owner = '81'

answered Feb 26 '15 at 21:09

SoulTrain

2 Answers2