PHP, MySQL SELECT FROM WHERE Clause

[ianhull]

Hi guys,

I need to select all the records in a table using the WHERE clause
but my problem is I need to select everything WHERE courseowner is not null or empty

Please help.

Thanks

[ianhull]

Any ever used a dummy $var to do this?

Thanks

[azmanar]

Any ever used a dummy $var to do this?

Thanks

SELECT * FROM mytable WHERE courseowner!=""

or

SELECT * FROM mytable WHERE courseowner NOT NULL