MySQL Forums
Forum List  »  Newbie

extracting not null
Posted by: scarlsen30
Date: August 06, 2004 09:38AM

I need to find a way to extract all not null fields from a table.

i tried

SELECT last_name, first_name
FROM ssfeatured
WHERE last_name NOT NULL
ORDER BY last_name

but i get a syntax error.

any help would be appreciated.

Options: ReplyQuote

Written By
extracting not null
August 06, 2004 09:38AM
August 06, 2004 09:51AM
August 06, 2004 10:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.