Simple data anonymization: Difference between revisions

Simple data anonymization (edit)

89 bytes removed , 29 July 2016

m

15,030

edits

@@ Line 53: / Line 53: @@
 -- SET @name := "Guo da-xia";
-SELECT CASE
+SELECT CONCAT(LEFT(@name, 1), 'OO', RIGHT(@name, CHAR_LENGTH(@name)-3));
-    WHEN CHAR_LENGTH(@name) =2 THEN CONCAT(LEFT(@name, 1), 'OO')
-    ELSE CONCAT(LEFT(@name, 1), 'OO', RIGHT(@name, CHAR_LENGTH(@name)-3))
-    END;
 </pre>