SELECT * FROM TEST ORDER BY LENGTH(description) DESC;
该LENGTH
函数以字节为单位给出字符串的长度。如果要计算(多字节)字符,请改用以下CHAR_LENGTH
函数:
SELECT * FROM TEST ORDER BY CHAR_LENGTH(description) DESC;
MySQL:按字段大小/长度排序
SELECT * FROM TEST ORDER BY LENGTH(description) DESC;
该LENGTH
函数以字节为单位给出字符串的长度。如果要计算(多字节)字符,请改用以下CHAR_LENGTH
函数:
SELECT * FROM TEST ORDER BY CHAR_LENGTH(description) DESC;