Skip to content

Instantly share code, notes, and snippets.

@tobyjsullivan

tobyjsullivan/format-preserving-scrubber.sql

Created July 6, 2016 21:23
Show Gist options
  • Save tobyjsullivan/7a6732836ca8c768df21c9ad353ab81e to your computer and use it in GitHub Desktop.
Save tobyjsullivan/7a6732836ca8c768df21c9ad353ab81e to your computer and use it in GitHub Desktop.
Download ZIP
The Worst FP-scrubber ever
Raw
format-preserving-scrubber.sql
select
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
'Hello, world! What time is it? 7:03, I say!',
'9',
substring('0123456789', floor(rand()*10)+1, 1)
),
'8',
substring('0123456789', floor(rand()*10)+1, 1)
),
'7',
substring('0123456789', floor(rand()*10)+1, 1)
),
'6',
substring('0123456789', floor(rand()*10)+1, 1)
),
'5',
substring('0123456789', floor(rand()*10)+1, 1)
),
'4',
substring('0123456789', floor(rand()*10)+1, 1)
),
'3',
substring('0123456789', floor(rand()*10)+1, 1)
),
'2',
substring('0123456789', floor(rand()*10)+1, 1)
),
'1',
substring('0123456789', floor(rand()*10)+1, 1)
),
'0',
substring('0123456789', floor(rand()*10)+1, 1)
),
'z',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'y',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'x',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'w',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'v',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'u',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
't',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
's',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'r',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'q',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'p',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'o',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'n',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'm',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'l',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'k',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'j',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'i',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'h',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'g',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'f',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'e',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'd',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'c',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'b',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'a',
substring('abcdefghijklmnopqrstuvwxyz', floor(rand()*26)+1, 1)
),
'Z',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'Y',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'X',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'W',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'V',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'U',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'T',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'S',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'R',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'Q',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'P',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'O',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'N',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'M',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'L',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'K',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'J',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'I',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'H',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'G',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'F',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'E',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'D',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'C',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'B',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
),
'A',
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', floor(rand()*26)+1, 1)
)
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment