0

My jwqt5_rsform_submission_values table has a column FieldValue with two values that I would like to respectively change.

I want to change value1 to firstvalue and value2 to secondvalue.

My PHP/Joomla code:

$db = JFactory::getDbo();
$db->setQuery("UPDATE `jwqt5_rsform_submission_values` SET `FieldValue` = 'firstvalue' WHERE `FieldValue` = 'value1'");
return $db->loadResult();

$db1 = JFactory::getDbo();
$db1->setQuery("UPDATE `jwqt5_rsform_submission_values` SET `FieldValue` = 'secondvalue' WHERE `FieldValue` = 'value2'");
return $db1->loadResult();

Can this update be executed in a single query?

mickmackusa
  • 43,625
  • 12
  • 83
  • 136
saeed
  • 19
  • 1
  • 6

1 Answers1

0

You can combine the queries like this:

UPDATE jwqt5_rsform_submission_values
SET FieldValue = CASE FieldValue
    WHEN 'value1' THEN 'firstvalue'
    WHEN 'value2' THEN 'secondvalue'
END
WHERE FieldValue IN ('value1', 'value2')
Barmar
  • 741,623
  • 53
  • 500
  • 612