SQL query to match multiple values to a field in select statement

Question

I want to select distinct values of Column A where Column B = any members of a set S.

Is there a way to do this directly in SQL without looping and then filtering afterwards in code?

Thanks

EDIT: The set S is a PHP array. Does this make a difference?

What flavor of mysql library in PHP are you using? mysql, mysqli, PDO, etc.? — Decent Dabbler
– Decent Dabbler, Commented Sep 30, 2011 at 7:11

antyrat · Accepted Answer · 2011-09-30 12:22:37Z

6

Use the IN clause with a list of values, or a subquery (not sure if supported in MySql since I use Oracle). The match can be on more than one column.

SELECT column_a
  FROM mytable
 WHERE column_b IN (1, 2, 3)

SELECT column_a
  FROM mytable
 WHERE column_b IN (SELECT column_c FROM myothertable)

edited Sep 30, 2011 at 12:22

antyrat

27.7k9 gold badges78 silver badges77 bronze badges

answered Sep 30, 2011 at 7:03

Iain

762 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Decent Dabbler Over a year ago

Yes it is supported by MySQL.

Decent Dabbler · Accepted Answer · 2011-09-30 06:59:31Z

2

SELECT DISTINCT
    columnA
FROM
    yourTable
WHERE
    columnB IN ( 'your', 'set', 'of', 'values' )

answered Sep 30, 2011 at 6:59

Decent Dabbler

22.8k11 gold badges77 silver badges107 bronze badges

Collectives™ on Stack Overflow

SQL query to match multiple values to a field in select statement

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related