Changes between Version 10 and Version 11 of AdminTips


Ignore:
Timestamp:
2012-09-12T21:58:28Z (12 years ago)
Author:
Pan Luo
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AdminTips

    v10 v11  
    7878}}}
    7979
    80 ==== Export Groups ====
     80=== Remove the Leading "s" in Username ===
     81{{{
     82#!sql
     83UPDATE users SET username = SUBSTRING(username, 2) WHERE username REGEXP 's[0-9]{8}';
     84}}}
     85
     86=== Export Groups ===
    8187{{{
    8288#!sql