MySQL SELECT statement for field "length" greater than 1

Question

I have a LINK field in my table. Some lines have a link, some do not.

I would like to select all the lines in which LINK is present. (length greater than X characters).

How do I write this?

Answer 1

What about:

SELECT * FROM sometable WHERE CHAR_LENGTH(LINK) > 1 

Here is the MySql (5.0) line functions page .

Note that instead of LENGTH I chose CHAR_LENGTH , as if the data that you are probably really interested in is how many characters there are, and not how many bytes of memory that they accept, there are multibyte characters. Thus, for the above, a string in which LINK is the only double-byte character will not be returned, whereas when using LENGTH .

Note that if LINK is NULL , the result of CHAR_LENGTH(LINK) will also be NULL , so the string will not match.

Answer 2

 select * from [tbl] where [link] is not null and len([link]) > 1 

For MySQL user:

 LENGTH([link]) > 1 

Answer 3

Just in case, someone wants to find, as in an oracle, and came here (like me), the syntax

 select length(FIELD) from TABLE 

just in case;)

Answer 4

Try:

 SELECT * FROM YourTable WHERE CHAR_LENGTH(Link) > x