The OR search operator
You can use an OR operator to search for multiple types of results in a given property. For instance, if you are looking for contacts in your database that are located in Boston or New York, you can enter your search so that City / contains / "Boston" OR "New York":
Please note that the OR operator must be in all capital letters. You can also combine an OR operator search with a wildcard search using the * search function . For instance, if you want to filter freemail addresses, you can build a filter that looks like this:
The AND search operator
The AND search operator is used to search for multiple values within a single property entry. For instance, if you want to search for all results that have both hello and gmail.com in the email, try a search like the below:
Please note that the AND operator must be in all capital letters. With this filter, you'll segment out contacts whose email address includes both values, such as email@example.com.