---
schema_version: "1"
id: 30647ad03655af5f14258774d2ba61ef2ae99508b58bae7c2c828a1530308125
title: Query Multi-Select Picklists
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-soql-querying-multiselect-picklists.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-querying-multiselect-picklists.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 0f70f67c93a97095b50e047bb3972acd2dabb5dba014e313404382e7aecf435e
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# Query Multi-Select Picklists

You can search for individual values in multi-select picklists, which are regularly used in client applications.

Client applications use a specific syntax for querying multi-select picklists, which allows selection of multiple items . In API version 39.0 and later, query for picklist values by the value’s API name, which can be different from the actual value.

The following operators are supported for querying multi-select picklists:

| Operator   | Description                                                                                                        |
| ---------- | ------------------------------------------------------------------------------------------------------------------ |
| `=`        | Equals the specified string.                                                                                       |
| `!=`       | Does not equal the specified string.                                                                               |
| `includes` | Contains the specified string.                                                                                     |
| `excludes` | Does not contain the specified string.                                                                             |
| `;`        | Specifies AND for two or more strings. Use `;` for multi-select picklists when two or more items must be selected. |

Example `;` operator:

```nolang
'AAA;BBB'
```

## Examples

The following query filters on values in the `MSP1__c` field that are equal to `AAA` and `BBB` selected (exact match):

```soql
SELECT Id, MSP1__c FROM CustObj__c WHERE MSP1__c = 'AAA;BBB'
```

In the following query:

```soql
SELECT Id, MSP1__c from CustObj__c WHERE MSP1__c includes ('AAA;BBB','CCC')
```

the query filters on values in the `MSP1__c` field that contains either of these values:

- `AAA` and `BBB` selected.
- `CCC` selected.

A match will result on any field value that contains 'AAA' and 'BBB' or any field that contains 'CCC'. For example, the following will be matched:

- matches with ' `AAA;BBB`':

```nolang
             'AAA;BBB'
             'AAA;BBB;DDD'
```

- matches with ' `CCC`':

```nolang
             'CCC'
             'CCC;EEE'
                      'AAA;CCC'
```