[SOLVED] MySQL 'if' STATEMENT

[xProteuSx]

I am wondering if there is any sort of 'if' statement for MySQL.  What I am trying to do is something that looks like this:

 

SELECT * WHERE column1 !=' '

 

So basically I want to select rows where column1 is not empty, or null.  I know that I can select all rows, then filter them using PHP, but I would really like to do this using MySQL if possible.

 

Thanks.

[trq]

SELECT * WHERE column1 != ''

[corbin]

Or, if nulls are allowed, you might want to try:

 

SELECT * FROM table WHERE column1 != '' AND colum1 IS NOT NULL;