[Resolved] where clause question

[asa_carter]

How do I use the Where clause to select a row that only contains data?

For example

SELECT * FROM rooms WHERE date='$newdate' AND room5 {is not empty}

Thanks

Asa

[madwormer2]

AND room5 != ''

Where room5 is not equal to [no data]