MySQL: 按字段大小/长度排序

下面是一个表结构(例如 test) :

例如:

SELECT * FROM TEST ORDER BY description DESC;

但我想订购的 字段大小/长度的现场说明。

字段类型将是 TEXT 或 BLOB。

87733 次浏览

小开

最佳答案

SELECT * FROM TEST ORDER BY LENGTH(description) DESC;

The LENGTH function gives the length of string in bytes. If you want to count (multi-byte) characters, use the CHAR_LENGTH function instead:

SELECT * FROM TEST ORDER BY CHAR_LENGTH(description) DESC;

小开

SELECT * FROM TEST ORDER BY CHAR_LENGTH(description);

小开

For those using MS SQL

SELECT * FROM TEST ORDER BY LEN(field)