Update two different strings in one column in mysql

Question

Good day, I have a simple question here where I want to update my column whenever these two value are used.

UPDATE products SET description='YES' WHERE description='PENDING'

other than 'PENDING', I also want 'NO' to be included in this query for update.

What can I do? I want it to be updated on any row I update/click, Thank you.

senthilkumar2185 · Accepted Answer · 2014-11-06 07:39:33Z

1

update products
set description = 
case 
when description='PENDING' then 'YES'
else 'NO'
end

answered Nov 6, 2014 at 7:39

senthilkumar2185

2,5983 gold badges23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pavel · Accepted Answer · 2014-11-06 07:44:41Z

0

Are you looking for st. like this?

UPDATE products 
SET description='YES' 
WHERE description IN ('PENDING','NO') AND
      id = 3

It sets description="YES" to all rows where description is equal to PENDING or NO.

edited Nov 6, 2014 at 7:44

answered Nov 6, 2014 at 7:33

pavel

27.3k11 gold badges47 silver badges63 bronze badges

9 Comments

Confuser Over a year ago

Hi, @panther, yeah, it's almost what I want, but it changes all the row. I just want that particular row to change.

pavel Over a year ago

Just add second condition, I updated my answer. For exaple row ID, or st. else what´s is unique for row you want to change.

Confuser Over a year ago

What if I want every distinct id to be able to change, not only a single one like declared above? Whenever I click on any of the row, and only that row will change, and others also.

pavel Over a year ago

I don´t know what you want... For changing single row (or more rows using more IDs in query) use my code, if you want to change ALL rows, just leave id=3. Do you want to change multiple lines, which lines? How to define them?

Confuser Over a year ago

I want to change one value in the row, without affecting the whole column. for example, I want pending of that row change into yes, the other data in the column remain the same.

|

Ronak Shah · Accepted Answer · 2014-11-06 09:32:41Z

0

try below:

UPDATE products SET description=if(<Your Condition to set Value YES>,'YES','NO') WHERE description='PENDING'

edited Nov 6, 2014 at 9:32

answered Nov 6, 2014 at 7:32

Ronak Shah

1,5592 gold badges13 silver badges20 bronze badges

6 Comments

Confuser Over a year ago

I want it to be able to update each 'pending' and change it to 'yes' or 'no' for each row, not update all the column data.

Ronak Shah Over a year ago

@Confuser.. I have updated answer. What is your condition to set description "Yes" or "NO"

Confuser Over a year ago

my condition is different id? is it possible? for different id, set yes to replace the pending. So it won't update the whole column with same pending value.

Ronak Shah Over a year ago

What do you mean by different id? Please explain more

Confuser Over a year ago

Means, every single row with different id, I'll be able to change it individually, not change "yes" and all became "yes".

|

Collectives™ on Stack Overflow

Update two different strings in one column in mysql

3 Answers 3

Comments

9 Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

9 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related