"is NOT NULL" in the whare close 26/12/2001 16:46:44, Gilles Missonnier <[EMAIL PROTECTED]> wrote:
>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 > > > --------------------------------------------------------------------- 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