Skip to content

Instantly share code, notes, and snippets.

@brunomichetti
Created Sep 13, 2022
Embed
What would you like to do?
UPDATE "targets_user"
SET "username" = CAST(
CASE
WHEN ("targets_user"."id" = 122) THEN \'mirandafry\'
WHEN ("targets_user"."id" = 123) THEN \'kimberlyford\'
WHEN ("targets_user"."id" = 124) THEN \'charlesbrewer\'
WHEN ("targets_user"."id" = 125) THEN \'tylergarcia\'
WHEN ("targets_user"."id" = 126) THEN \'joshuaperez\'
WHEN ("targets_user"."id" = 127) THEN \'aprilalexanderdds\'
WHEN ("targets_user"."id" = 128) THEN \'bethanyherrera\'
WHEN ("targets_user"."id" = 129) THEN \'phillipgarza\'
WHEN ("targets_user"."id" = 130) THEN \'janicemoore\'
WHEN ("targets_user"."id" = 131) THEN \'jenniferlopez\'
WHEN ("targets_user"."id" = 132) THEN \'hannahmcfarland\'
WHEN ("targets_user"."id" = 133) THEN \'jillianallen\'
WHEN ("targets_user"."id" = 134) THEN \'jefferywillis\'
WHEN ("targets_user"."id" = 135) THEN \'stevenstanton\'
WHEN ("targets_user"."id" = 136) THEN \'melaniemoses\'
ELSE NULL END AS varchar(50)
)
WHERE "targets_user"."id" IN (122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment