mySQL: Order by field size/length
Posted
by Sadi
on Stack Overflow
See other posts from Stack Overflow
or by Sadi
Published on 2010-04-03T17:50:47Z
Indexed on
2010/04/03
17:53 UTC
Read the original article
Hit count: 211
Here is a table structure (e.g. test):
__________________________________________
| Field Name | Data Type |
|________________|_________________________|
| id | BIGINT (20) |
|________________|_________________________|
| title | varchar(25) |
|________________|_________________________|
| description | text |
|________________|_________________________|
A query like:
SELECT * FROM TEST ORDER BY description;
But I would like to order by the field size/length of the field description. The field type will be TEXT or BLOB.
© Stack Overflow or respective owner
