How to select one text column, which string length >0 ?

Question

Is there any function like "strlen" in mysql?

Answer 1

Mysql does have a length function to return the length of a string.

so you could do something like.

select * from some_table where length(some_string) > 0;

Answer 2

The following query would do the job for you.

select length(your_text_column) from sample_table where length(some_column) > 0

Answer 3

How to select one text column, which string length >0 ?

You could compare to the empty string:

SELECT yourcolumn
FROM yourtable
WHERE yourcolumn <> ''

Answer 4

You can do it with using LENGTH keyword

SELECT * FROM table WHERE LENGTH (name) > 150;