Created
July 6, 2016 21:23
-
-
Save tobyjsullivan/7a6732836ca8c768df21c9ad353ab81e to your computer and use it in GitHub Desktop.
The Worst FP-scrubber ever
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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