Swap Organizers (TEC/ECP)

-- The "wp_" table prefix may be different in your
-- installation, however it is the postmeta table
-- that we wish to alter here
UPDATE wp_postmeta

-- 182 is the "target ID" - the ID of the organizer
-- we wish to keep
SET meta_value = '182'

-- This means we are interested in the current
-- organizer ID
WHERE meta_key = '_eventOrganizerID'
AND (
    -- This is essentially a list of organizers
    -- we wish to dispose of (using their IDs)
    meta_value = '208' OR
    meta_value = '204'
);