Simple data anonymization: Difference between revisions

Simple data anonymization (edit)

196 bytes added , 29 July 2016

15,030

edits

@@ Line 14: / Line 14: @@
 ** {{kbd | key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, "OO")</nowiki>}} also applied for 3 or 4 words
 ** {{kbd | key=<nowiki>=REPLACE(A2, 2, 2, "O")</nowiki>}} {{exclaim}} only applied for 3 words, NOT for 4 words
-* MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}}
+* MySQL:
+<pre>
+-- SET @name := "楊過"; /* 楊過 -> 楊OO */
+SET @name := "王小明"; /* 王小明 --> 王OO */
+-- SET @name := "孤獨求敗"; /* 孤獨求敗 --> 孤OO */
+-- SET @name := "Guo da-xia"; /* Guo da-xia --> GOO */
+SELECT CONCAT(LEFT(@name, 1), 'OO');
+</pre>
 == case2: 王小明 --> 王O明 ==