Multi-value properties cannot be specified in the SELECT clause and are excluded when the SELECT clause specifies a “*”.
In the WHERE clause the comparison operators function the same way they do in XPath when applied to multi-value properties: if the predicate is true of at least one value of a multi-value property then it is true for the property as a whole (see 6.6.4.10 Searching Multi-value Properties).