Mysql WHERE command for multiple values

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rahulephp
Forum Commoner
Posts: 28
Joined: Mon Oct 05, 2009 11:05 am

Mysql WHERE command for multiple values

Post by rahulephp »

Please help me to find out the solution.
I want to fetch data from "product" table where "Product_id"(s) are 5,8,9,12...

I am using the query:

Code: Select all

SELECT * FROM products WHERE product_id=5 OR product_id=7 
OR product_id=8 
OR product_id=9 
OR product_id=12 
But i dont want to use "product_id=" again and again many time.

Just wondering if there any sql syntax like "SELECT * FROM products WHERE product_id=(5,8,9,12)" ?
Above statement is only a assumption but wanted to know if there is anything possible like this.

Thanks in anticipation
rahulephp
Forum Commoner
Posts: 28
Joined: Mon Oct 05, 2009 11:05 am

Re: Mysql WHERE command for multiple values

Post by rahulephp »

Got the solution:

Code: Select all

SELECT *
FROM `products`
WHERE product_id
IN ('5','8','9','12');
Post Reply