How to update many rows with Where clause

Question

I have table with rows below:

id |  s1  |  s2  |  s3  |  s4  |  s5  |
---------------------------------------
1  |  6   |  2   | null | null | null |
---------------------------------------
2  |  8   |  1   | null | null | null |

I have already this values, and I want to add data to cells where null

My query is:

UPDATE table1
SET s3 = "some_s3" WHERE id = 1
SET s4 = "some_s4" WHERE id = 1
SET s5 = "some_s5" WHERE id = 1
SET s3 = "some_s3" WHERE id = 2
SET s4 = "some_s4" WHERE id = 2
SET s5 = "some_s5" WHERE id = 2

Something like this. But i need to update thousand rows.

Answer 1

UPDATE table1 SET s3='some_value1',s4='some_value2',s5='some_value3'

WHERE s3 is null and s4 is null and s5 is null

Answer 2

try:

 UPDATE table1
SET s3 = "some_s3" WHERE s3 is null
 UPDATE table1
SET s4 = "some_s4" WHERE s4 is null
 UPDATE table1
SET s5 = "some_s5" WHERE s5 is null

Answer 3

Well, the easiest way is to write a PHP script if you want to update large amounts of data.