Updating Custom Field Values in MailWizz using SQL

Identify the field_ids using this SQL

SELECT * FROM `mw_list_field`

Then run the update using SQL

SELECT 
	* 
FROM 
	mw_list_field_value
where
	field_id IN (24, 38)
	AND value = 'D'
;

update mw_list_field_value
	set
		value = 'E'
	where
		field_id IN (24, 38)
		AND value = 'D'
;

update mw_list_field_value
	set
		value = 'D'
	where
		field_id IN (24, 38)
		AND value = 'C'
;

update mw_list_field_value
	set
		value = 'C'
	where
		field_id IN (24, 38)
		AND value = 'B'
;

update mw_list_field_value
	set
		value = 'B'
	where
		field_id IN (24, 38)
		AND value = 'A'
;