SQL question / advice

[eluser]drewbee[/eluser]
The Distinct Keyword is what you are looking for. Using the IN keyword also helps clean this up a little bit.

For every value passed to an IN(x,y,z) column = x OR column = y OR column = z

Code:

SELECT DISTINCT product_id FROM table WHERE cat_id IN ('123', '125')

Code:

SELECT DISTINCT product_id FROM table WHERE cat_id IN ('123', '126')