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',
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 th
