[RESOLVED] Select statement with multiple WHERE clause

wheeler08

I want to select multiple rows from a table based on the user's id.

For example,

Rob - 100
John - 101
Sarah -102

$query = "SELECT * FROM Users WHERE userID='100' AND userID='101' AND userID='102'";

How do I write it so that I can select all three users, based on their ID at the same time?

harmor

I am taking a shot in the dark but try

 $query = "SELECT * FROM Users WHERE userID='100', '101', '102' ";

jernhenrik

If the UserID is a integer in your database the query could look like this:

$query = "SELECT * FROM Users WHERE userID=100 OR userID=101 OR userID=102";

wheeler08

Bingo! Using the OR clause will do the trick. Using commas doesn't seem to be working.

efficacious

heres one that I just needed to use

took a bit to figure out for me so why not post it for others to come across later aye.

SELECT DISTINCT 'user' FROM 'userTable' WHERE date='TheDate' AND time BETWEEN 'time1' AND 'time2'

This exact same query above would not run correctly if written this way below:

SELECT DISTINCT 'user' FROM 'userTable' WHERE time BETWEEN 'time1' AND 'time2' AND date='TheDate'

hope this helps some1 else 🙂

bradgrafelman

efficacious;10989334 wrote:
This exact same query above would not run correctly if written this way below:
SELECT DISTINCT 'user' FROM 'userTable' WHERE time BETWEEN 'time1' AND 'time2' AND date='TheDate'  

Works just fine for me:

mysql> CREATE TABLE userTable (
    ->   var1 VARCHAR(30),
    ->   var2 INT
    -> );
Query OK, 0 rows affected (0.57 sec)

mysql> INSERT INTO userTable (var1, var2) VALUES ('test', 1), ('test', 2),
    ->   ('test', 3), ('test', 4), ('oops', 2);
Query OK, 5 rows affected (0.50 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM userTable WHERE var2 BETWEEN 2 AND 4 AND var1='test';
+------+------+
| var1 | var2 |
+------+------+
| test |    2 |
| test |    3 |
| test |    4 |
+------+------+
3 rows in set (0.00 sec)