mysql 隐藏中间名字SQL
SELECT CONCAT(left(user_name_real, 1), '*',substring(user_name_real,3) ) FROM userinfo;
UPDATE userinfo SET user_name = CONCAT(left(user_name_real, 1), '*',substring(user_name_real,3) ) ;
mysql 隐藏中间名字SQL
SELECT CONCAT(left(user_name_real, 1), '*',substring(user_name_real,3) ) FROM userinfo;
UPDATE userinfo SET user_name = CONCAT(left(user_name_real, 1), '*',substring(user_name_real,3) ) ;