centenial Posted July 3, 2006 Share Posted July 3, 2006 Hi,Does anyone know the MySQL Query for selecting all fields from a table where the fieldvalues do NOT equal nothing?Thanks! Link to comment https://forums.phpfreaks.com/topic/13558-select-from-table-where-fieldvalue/ Share on other sites More sharing options...
fenway Posted July 3, 2006 Share Posted July 3, 2006 If only it was that simple... I assume you mean where all field value for a particular row are not blank. Unfortunately, without actually checking each one, it's a pain, and even if you do, you'd have to change the column list dynamically, which you can't do either. What are you trying to accomplish? Link to comment https://forums.phpfreaks.com/topic/13558-select-from-table-where-fieldvalue/#findComment-52506 Share on other sites More sharing options...
king arthur Posted July 5, 2006 Share Posted July 5, 2006 Do you mean "SELECT FROM table WHERE fieldvalue IS NOT NULL" ? Link to comment https://forums.phpfreaks.com/topic/13558-select-from-table-where-fieldvalue/#findComment-53352 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.