From: Claudio Nanni
Date: June 11 2011 9:41am
Subject: Re: How to find values which do not return any tuple in "IN" clause
List-Archive: http://lists.mysql.com/mysql/225227
Message-Id: <BANLkTikug7uUL_5uKqqHrVy3ShQh-EGhSw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=90e6ba6e8438c5be2c04a56c7dc3

--90e6ba6e8438c5be2c04a56c7dc3
Content-Type: text/plain; charset=ISO-8859-1

Sorry but my mail was in "sending state" since last night, and only now was
sent.

Ignore it.

Claudio


2011/6/11 Claudio Nanni <claudio.nanni@stripped>

> Hi Fahim,
>
> Could you please explain better what you mean exactly?
> I think the question is not very clear.
> Thanks
>
> Claudio
> On Jun 11, 2011 12:36 AM, "Fahim Mohammad" <fahim.md@stripped> wrote:
> > Hi
> >
> > select * from tablename where fieldname in ('aaa','bbb','ccc','ddd');
> >
> > return only the successful hit.
> >
> > How can I know how many out of four ('aaa','bbb','ccc','ddd') resulted in
> a
> > miss OR which values do not return any tuple.
> >
> > Thanks
> >
> > Fahim
>



-- 
Claudio

--90e6ba6e8438c5be2c04a56c7dc3--