oracle259 Posted October 13, 2006 Share Posted October 13, 2006 How do i order my mysql results by the longest length egI have the following words in the dbstringstringeststringerhow do i get the following resultsstringeststringerstring Link to comment https://forums.phpfreaks.com/topic/23871-arranging-mysql-result-by-result-length/ Share on other sites More sharing options...
fenway Posted October 13, 2006 Share Posted October 13, 2006 ORDER BY LENGTH(yourField) DESC Link to comment https://forums.phpfreaks.com/topic/23871-arranging-mysql-result-by-result-length/#findComment-108559 Share on other sites More sharing options...
oracle259 Posted October 13, 2006 Author Share Posted October 13, 2006 thanks u guys rock. Link to comment https://forums.phpfreaks.com/topic/23871-arranging-mysql-result-by-result-length/#findComment-108611 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.