select * from `table` where `field` != "";should do it. I should think the type conversion would kick in if it were NULL as well.