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! Quote Link to comment 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? Quote Link to comment 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" ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.