0
------------------------------
| member          | place    |
|-----------------|----------|
| 3               | 1        |
| 6               | 2        |
| s8d9fg8328d55   | 1        |
| 744             | 2        |
------------------------------

What I want is a query, that will pair 2 members with the same place. Lets say:

Example 1:
------------------
SELECT `place` FROM `table` WHERE `member`='3' AND `member`='s8d9fg8328d55'
------------------  
Expected output: `place` = 1

Example 2:
------------------
SELECT `place` FROM `table` WHERE `member`='4' AND `member`='s8d9fg8328d55'
------------------  
Expected output: no rows

Thanks.

Dharman
  • 30,962
  • 25
  • 85
  • 135
Robin
  • 187
  • 1
  • 10

0 Answers0