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

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

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

--90e6ba6e8d90af0a8d04a56b2f0a--