Select From Table Where Fieldvalue != ""

Hi,

Does anyone know the MySQL Query for selecting all fields from a table where the fieldvalues do NOT equal nothing?

Thanks!

Code:

---

select * from `table` where `field` != "";

---

should do it. I should think the type conversion would kick in if it were NULL as well.