79288003

Date: 2024-12-17 13:17:05
Score: 2
Natty:
Report link

First query runs over all records in table so try WHERE closure which will be faster :)

UPDATE tbl_name SET field_name = CASE WHEN condition_1 THEN 'Blah' WHEN condition_2 THEN 'Foo' WHEN condition_x THEN 123 ELSE 'bar' END AS value WHERE fieldname IN (condition_1, condition_2, condition_x)

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: jaszczomp