PostgreSQL:Update

UPDATE table_name SET field_name=CASE WHEN field_name='exp1' THEN 'result1'
                                                             WHEN field_name='exp2' THEN 'result2'
                                                             ELSE 'other'
                                                             END;