MySQL Forums
Forum List  »  Newbie

Simple Select Statement
Posted by: Mike Herber
Date: July 18, 2005 10:56AM

I have a database that has a column of int named crsnum.

I need to select data from this db omiting certian crsnum's, and a certin email match from the email field example:

"SELECT * FROM login
WHERE (Email = '$email') ORDER BY ID DESC";

Works great but I need to add " WHERE Crsnum != 1,3,6,9,19 " so these crsnums are omited from the select.

Any ideas?

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Simple Select Statement
July 18, 2005 10:56AM


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.