Mysql WHERE command for multiple values
Posted: Sat Apr 24, 2010 8:29 am
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:
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
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 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