Re: Basic SELECT help

[Mike OK]

Hi Neil

Would something like this work.

SELECT DISTINCT id,type from your_table WHERE type=2 OR type=5;

Mike


----- Original Message ----- 
From: "Neil Tompkins" <neil.tompkins@stripped>
To: "[MySQL]" <mysql@stripped>
Sent: Thursday, November 22, 2012 9:30 AM
Subject: Basic SELECT help


> Hi,
>
> I'm struggling with what I think is a basic select but can't think how to
> do it : My data is
>
> id,type
>
> 1000,5
> 1001,5
> 1002,2
> 1001,2
> 1003,2
> 1005,2
> 1006,1
>
> From this I what to get a distinct list of id where the type equals 2 and 
> 5
>
> Any ideas ?
>
> Neil
>