create table dim (value varchar(10), primary key(value));
insert into dim values ('aaa'),('bbb'),('ccc'),('ddd');
SELECT tablename.fieldname
FROM dim
LEFT JOIN tablename ON tablename.fieldname = dim
WHERE tablename.fieldname IS NULL;
If this is not what intended, I'd suggest you to spend a little more
effort in formulating a more clear question, maybe with an example.
-NT
Em 10-06-2011 23:36, Fahim Mohammad escreveu:
> 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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
