mysql從大到小排序 mysql字符串?dāng)?shù)字排序?
mysql字符串?dāng)?shù)字排序?創(chuàng)建表格:按左鍵選擇*從測(cè)試順序(STR,1),轉(zhuǎn)換(substr(STR,2,length(STR)-1),帶符號(hào))Mysql字符串中有數(shù)字的排序問題?根據(jù)實(shí)際情況選擇id
mysql字符串?dāng)?shù)字排序?
創(chuàng)建表格:按左鍵選擇*從測(cè)試順序(STR,1),轉(zhuǎn)換(substr(STR,2,length(STR)-1),帶符號(hào))
Mysql字符串中有數(shù)字的排序問題?
根據(jù)實(shí)際情況選擇id,col,length(col)從D order按length(col)ASC,col ASC
或
按cast從D order選擇id,col(trim(“Chinese”from col)as signed)