Changes between Version 10 and Version 11 of AdminTips

Timestamp:

2012-09-12T21:58:28Z (13 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -78 +78 @@
 }}}
 
-==== Export Groups ====
+=== Remove the Leading "s" in Username ===
+{{{
+#!sql
+UPDATE users SET username = SUBSTRING(username, 2) WHERE username REGEXP 's[0-9]{8}';
+}}}
+
+=== Export Groups ===
 {{{
 #!sql