Hi ! I need a help on the syntax.
My table has over 100 different fields: I want to display only the "NOT NULL" fields and also the names of these "NOT NULL" fields. so the simple mysql command : mysql> select * from tabID where tabID.login='john'; returns a long ... long line, with many items that are NULL. and I would try something like : mysql> select * from tabID where tabID.login='john' and tabID.* NOT NULL; but the syntax is wrong ... the point is : how to use the "*" or a wild card ? my MySQL version is 3.22.22 on DIGITAL osf1 cheers, ================================== Gilles MISSONNIER - Projet Terapix phone : [33] 01 44 32 81 36 http://terapix.iap.fr --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php