An SQL question.
Posted: Thu Mar 29, 2007 7:15 pm
Sorry I don't know if this is in the right forum.
Question:
How could I select the rows where the field "entry" is either "foo" or "bar"?
I think something like:
Would this work or is there a correct way?
Also, to I have to select class and entry in order to use these fields in the WHERE clause?
Thank for reading my post. I'd appreciate any help on this.
Question:
How could I select the rows where the field "entry" is either "foo" or "bar"?
I think something like:
Code: Select all
SELECT class, entry, value FROM $table_name WHERE class = 'manager' AND entry = ('foo' OR 'bar');
Also, to I have to select class and entry in order to use these fields in the WHERE clause?
Thank for reading my post. I'd appreciate any help on this.