Couldn't it be something like:
WHERE ('a' IN ('a','b','c','d')
OR 'f' IN ('a','b','c','d')
OR 'g' IN ('a','b','c','d')
)
On Tue, 2004-01-13 at 15:34, Eli Hen wrote:
> Hello All,
>
> In MySQL it is possible to check if an element is existing in a group, like:
>
> ... WHERE 'a' IN ('a','b','c','d') ...
>
> but that checks one element only.
> I want to check if any element from a group exists in another group, like:
>
> ... WHERE ('a','f','g') IN ('a','b','c','d') ...
>
> 'a' in the first group appears in the second group, so it will return true,
> no matter if 'f' or 'g' exist in too.
>
> Well, is there anything like above that I can use?
>
> -thanks, Eli
--
Diana Soares
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
