PDA

View Full Version : Select From Table Where Fieldvalue != ""



centenial
07-03-2006, 05:07 PM
Hi,

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

Thanks!

Twey
07-03-2006, 07:31 PM
select * from `table` where `field` != "";should do it. I should think the type conversion would kick in if it were NULL as well.