From: marek gutowski
Date: November 22 2012 2:39pm
Subject: Re: Basic SELECT help
List-Archive: http://lists.mysql.com/mysql/228683
Message-Id: <CABYzjMGEBX0fQ9P1f1ybucaUYc5m6e0g48jbfT49_m=4Ns-PCQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b62243c491a6a04cf166fd2

--047d7b62243c491a6a04cf166fd2
Content-Type: text/plain; charset=ISO-8859-1

SELECT DISTINCT id FROM table WHERE type IN ('2','5')

should work


On 22 November 2012 14:30, Neil Tompkins <neil.tompkins@stripped>wrote:

> 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
>

--047d7b62243c491a6a04cf166fd2--