Select From Table Where Fieldvalue != ""

[centenial]

Hi,

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

Thanks!

[Twey]

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

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