select REPLACE(full_name,substring(full_name,2,len(full_name)),'**') from subject
--update subject set full_name=REPLACE(full_name,substring(full_name,2,len(full_name)),'**')
select REPLACE(full_name,substring(full_name,2,len(full_name)),'**') from subject
--update subject set full_name=REPLACE(full_name,substring(full_name,2,len(full_name)),'**')
转载于:https://www.cnblogs.com/keepSmile/p/10729682.html