mysql排序并重新设置编号

SET @row_number = 0;

update ichuk_system_bookinfo set sortid= (@row_number:=@row_number+1) where user_id=61

order by

f1,

field(f2,"/","-",":","."),

if((f2="/" || f2=":"), if(f3 REGEXP '^-?[0-9]+$',(CAST(f3 AS UNSIGNED)*1),0) ,0),

if(!(f2="/" || f2=":"),f3,0),

field(f4,"/","-",":","."),

if((f4="/" || f4=":"), if(f5 REGEXP '^-?[0-9]+$',(CAST(f5 AS UNSIGNED)*1),0) ,0),

if(!(f4="/" || f4=":"),f5,0),

field(f6,"/","-",":","."),

if((f6="/" || f6=":"), if(f7 REGEXP '^-?[0-9]+$',(CAST(f7 AS UNSIGNED)*1),0) ,0),

if(!(f6="/" || f6=":"),f7,0),

field(f8,"/","-",":","."),

if((f8="/" || f8=":"), if(f9 REGEXP '^-?[0-9]+$',(CAST(f9 AS UNSIGNED)*1),0) ,0),

if(!(f8="/" || f8=":"),f9,0),

field(f10,"/","-",":","."),

bcode;

©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

推荐阅读更多精彩内容