MySQL: update row based on if condition

Question

How do I update every column in a row if a certain condition in the column is met? Say if the status column of that row is 'underReview', then update the whole row with the request body. If the status column has other values, then do not execute the SQL query? I am using v8 btw.

I have tried the query below but it shows error.

IF ((SELECT status FROM tableName) = "underReview" WHERE id = ?) 
THEN
    UPDATE tableName
    SET columnA = ?, columnB = ?, columnC = ?, columnD = ?
    WHERE id = ?;
END IF

tnkh, welcome to the exquisite world of relational algebra, where procedural algorithms do not quite apply. Please, make no step further until you really understand what's implied on @Nick's answer. — Marcus Vinicius Pompeu
– Marcus Vinicius Pompeu, Commented Sep 27, 2019 at 4:16

Nick · Accepted Answer · 2019-09-27 03:39:12Z

3

Just add the condition on status to the WHERE clause in the UPDATE:

UPDATE tableName
SET columnA = ?, columnB = ?, columnC = ?, columnD = ?
WHERE id = ? AND status = 'underReview';

answered Sep 27, 2019 at 3:39

Nick

147k23 gold badges67 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

MySQL: update row based on if condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related