Skip to main content

Difference between “equals”, “contains”, and “in” conditions

Updated this week

When building rules in Elovate’s rule builder, the condition type determines how the system matches your filter value against Magento data. Using the wrong one can lead to missing or unexpected results.


1. Equals

  • Definition: Matches the value exactly.

  • When to use: You know the exact attribute value in Magento.

  • Example:

    • Rule: SKU equals NIKE-123

    • Matches: NIKE-123

    • Does NOT match: NIKE-123-RED, nike-123 (case-insensitive but must be the exact text).


2. Contains

  • Definition: Matches any value that includes your search term anywhere in the field.

  • When to use: You only know part of the value or want partial matches.

  • Example:

    • Rule: Name contains Nike

    • Matches: Nike Running Shoes, Kids Nike Hoodie

    • Does NOT match: Adidas Running Shoes

Note: “Contains” is not exact — if your term is too short, it may pull in unrelated results.


3. IN

  • Definition: Matches any value from a comma-separated list.

  • When to use: You want to match multiple exact values in one condition.

  • Example:

    • Rule: SKU in NIKE-123, ADIDAS-456, PUMA-789

    • Matches: Any product with exactly one of those SKUs.

    • Does NOT match: Partial or misspelled SKUs.


Quick tip:

  • Equals = 1 exact match

  • Contains = partial match

  • IN = list of exact matches

Did this answer your question?