15,030
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
→case1: 王小明 --> 王OO
| Line 8: | Line 8: | ||
* 王小明 --> 王OO | * 王小明 --> 王OO | ||
* 孤獨求敗 --> 孤OO | * 孤獨求敗 --> 孤OO | ||
* Guo da-xia --> GOO | |||
| Line 22: | Line 23: | ||
SELECT CONCAT(LEFT(@name, 1), 'OO'); | SELECT CONCAT(LEFT(@name, 1), 'OO'); | ||
</pre> | </pre> | ||