MySQL SELECT statement for the length of the field is greater than 1

Question

I have an LINK field in my table  Some rows have a link  some don t   I d like to select all rows where LINK is present   length is greater than X characters    How do I write this

User · Answer

select   from  tbl  where  link  is not null and len  link    gt  1   For MySQL user    LENGTH  link    gt  1

User · Answer

How about   SELECT   FROM sometable WHERE CHAR LENGTH LINK   gt  1   Here s the MySql string functions page  5 0    Note that I chose CHAR LENGTH instead of LENGTH  as if there are multibyte characters in the data you re probably really interested in how many characters there are  not how many bytes of storage they take  So for the above  a row where LINK is a single two-byte character wouldn t be returned - whereas it would when using LENGTH   Note that if LINK is NULL  the result of CHAR LENGTH LINK  will be NULL as well  so the row won t match

User · Answer

Try   SELECT       FROM     YourTable WHERE     CHAR LENGTH Link   gt  x

User · Answer

Just in case anybody want to find how in oracle and came here  like me   the syntax is  select length FIELD  from TABLE   just in case

[mysql] MySQL SELECT statement for the "length" of the field is greater than 1

Examples related to mysql