Selecting non empty values

[ryanschefke]

Hello,

 

I have a table and some of the rows has an empty value in one of the columns. It is blank (in other words, it is not "NULL"). How do I only select the rows that have a value and are not empty. The SELECT WHERE value IS NOT NULL doesn't work, and I understand why since I am putting in blank values.

 

Thanks!

 

Ryan

[bastones]

According to MySQL Docs: http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#operator_is-not-null

 

I believe it goes with SELECT, so:

 

SELECT * IS NOT NULL

 

for instance. Try that and let me know if it works .

[fenway]

According to MySQL Docs: http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#operator_is-not-null

 

I believe it goes with SELECT, so:

 

SELECT * IS NOT NULL

 

for instance. Try that and let me know if it works .

I have no idea what you mean.

 

Do you mean blank or null?

[bastones]

According to MySQL Docs: http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#operator_is-not-null

 

I believe it goes with SELECT, so:

 

SELECT * IS NOT NULL

 

for instance. Try that and let me know if it works .

I have no idea what you mean.

 

Do you mean blank or null?

 

SELECT * IS NOT NULL FROM `users` WHERE `username` = '$username'

 

...is an example, I'm unsure whether this is right or wrong but it probably is right as SELECT * means selecting all fields.

[Mchl]

Try

SELECT * FROM table WHERE CHAR_LENGTH(fieldwithblanks)>0;