can we update different multiple rows of single field

[mohinder]

Update mto_test_pdtabl e_34 set mto_test_pdtabl e_34.model_code = 'gate_valve' where mto_test_pdtabl e_34.model_code ='gat' &
set mto_test_pdtabl e_34..model_cod e = 'conc_red' where mto_test_pdtabl e_34..model_cod e ='redc'

[orangeCat]

possible to UPDATE multiple columns at the same time. The syntax in this case would look like the following:

UPDATE "table_name "
SET column_1 = [value1], column_2 = [value2]
WHERE {condition}