String Functions - Upper, Lower

/*
  Lower Case => LCASE(String)
  text => Field Name
*/

SELECT LOWER(text) FROM `try`;

SELECT LCASE(text) FROM `try`;

/*
  Upper Case => UCASE(String)
  text => Field Name
*/

SELECT UPPER(text) FROM `try`;

SELECT UCASE(text) FROM `try`;

/* Select And Order */

SELECT text, CHAR_LENGTH(text) AS count FROM `try` ORDER BY CHAR_LENGTH(text) ASC;

SELECT text, CHAR_LENGTH(text) AS count FROM `try` ORDER BY CHAR_LENGTH(text) DESC;