MySQL - How to select data by string length

Question

SELECT   FROM table ORDER BY string length column     Is there a MySQL function to do this  of course instead of string length

User · Accepted Answer

You are looking for CHAR LENGTH   to get the number of characters in a string    For multi-byte charsets LENGTH   will give you the number of bytes the string occupies  while CHAR LENGTH   will return the number of characters

User · Answer

select   from  tablename  where 1 having length  fieldname    fieldlength    Example if you want to select from customer the entry s with a name shorter then 2 chars   select   from customer where 1   having length name  lt 2

User · Answer

The function that I use to find the length of the string is length  used as follows   SELECT   FROM table ORDER BY length column

User · Answer

select   from table order by length column     Documentation on the length   function  as well as all the other string functions  is available here

User · Answer

Having a look at MySQL documentation for the string functions  we can also use CHAR LENGTH   and CHARACTER LENGTH   as well

User · Answer

I used this sentences to filter   SELECT table field1  table field2 FROM table WHERE length field   gt  10    you can change 10 for other number that you want to filter

[mysql] MySQL - How to select data by string length

Examples related to mysql

Examples related to select

Examples related to string-length