导读:SELECT LEFT(`userid`,length(`userid`)-3),`userid`,123456,`uname`,`typeid` FROM `dede_admin` WHERE `id`>753LEFT(`userid`,lengt...
SELECT LEFT(`userid`,length(`userid`)-3),`userid`,123456,`uname`,`typeid` FROM `dede_admin` WHERE `id`>753
LEFT(`userid`,length(`userid`)-3)
意思是从左侧开始查询userid这一字段中除后三位的所有字符,length()是字段长度
到处excle表格时:
SELECT LEFT(`userid`,length(`userid`)-3) as 学科,`userid` as 账号,123456 as 密码,`typeid` as 所属栏目编号 FROM `dede_admin` WHERE `id`>753