----- Original Message ----- From: "Tracy Gems" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 28, 2004 5:59 PM Subject: display only populated fields
> > How do I go about only displaying fields that have data and are not empty or have NULL? > > It's a 112 column table so I only want to display the fields that have data. > > Thanks. > > select * from table where ......... > I don't think there's any way of doing that. I've been working with relational databases, mostly DB2, for over 20 years and have never seen anything like that - nor any need for it. I don't really see how it could work: since every row can be different from any other row and since a result set can only have a specified set of columns, what would you want to see if the 1st row had columns 1-10 non-blank and the remaining columns blank or null but the 2nd row had columns 1-10 BLANK or null and the remaining columns non-null? Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
