Update sql with 2 conditions

Question

Navigation

#1 by (4 votes)

2

I have a table with the STATUZ column
This column consists of 3 possible values: NEW, VISUALIZED, DISCARDED

I have a function where I need to implement a SQL row that updates my table and changes all the values in the STATUZ column to: DISCARDED

The logic is:

Refresh in: MyTable , the column: statuz - where it has the value NEW for DISCOUNTED, and where it has the value VISUALIZED for DISCARDED. (at once)

The command I'm using but has no effect is:

 UPDATE toyota_base SET statuz = 'DESCARTADO' WHERE statuz = 'NOVO' and statuz = 'VISUALIZADO';

All help is welcome. Thank you.

mysql sql sql-update

asked by anonymous 15.07.2015 / 23:39

1 answer

Checking time in java Loading on ajax

score 4 · Accepted Answer

statuz has only one value, so it no can be both NOVO and VISUALIZADO so the update does not change any registry.

Change AND (conjunction) by OR (disjunction)

UPDATE toyota_base SET
   statuz = 'DESCARTADO'
WHERE statuz = 'NOVO' or statuz = 'VISUALIZADO';

Or use the IN class () that will have the same effect.

UPDATE toyota_base SET
   statuz = 'DESCARTADO'
WHERE statuz IN('NOVO','VISUALIZADO');