MySQL Forums
Forum List  »  Newbie

Simple SELECT???
Posted by: William Stokes
Date: April 12, 2005 04:41AM

Hello

This is probably a simple select for most users here but I can't write it. I
need to select rows from one table which fulfills two WHERE options. The
second WHERE needs to have two values.

Something like this:
SELECT * FROM x_table WHERE (id = '$team') AND (type = 'Game')

but I need to select also second type. For example 'Practice'. So the 'id'
needs to be just one certain id number but I want to select both types
'Game' and 'Practice' for the team in question.

Can anyone help Please. I'm bit new with SQL

Thanks
-Will

Options: ReplyQuote


Subject
Written By
Posted
Simple SELECT???
April 12, 2005 04:41AM
April 12, 2005 06:22AM
April 12, 2005 07:07AM


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.