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

You can do it with using LENGTH keyword

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

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

For anyone who comes across this answer in Google, keep this in mind:

Actually, CHAR_LENGTH() should be a better choice. For multi-byte charsets LENGTH() will give you the number of bytes the string occupies, while CHAR_LENGTH() will return the number of characters

MySQL - How to select data by string length

Answer 5

The following query would do the job for you.

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