Select multiple values using the Select Layer By Attribute tool in ArcGIS Pro

Summary

Some workflows require selecting certain values on a map based on specific attributes. ArcGIS Pro provides the capability to select multiple features using the Select Layer By Attribute tool.

This article describes how to select multiple fire hydrant point features made by specific manufacturers in a neighborhood.

Procedure

Follow these steps to select multiple values using the Select Layer By Attribute tool in ArcGIS Pro.

1. Click Select By Attributes on the Map ribbon tab.
2. Configure the Select Layer By Attribute pane as follows:
   1. Select the feature layer for the Input Rows field. In this example, the Water_Hydrants layer is selected.
   2. Select New selection from the drop-down list in the Selection type field.
   3. Click the New expression icon to open the query builder.

Note: 
The query builder opens in the Clause mode by default. To open it in SQL mode, toggle the SQL option . Refer to ArcGIS Pro: Query builder for more information.

4. Insert the following query to select the first value:

For Clause mode:

Where '<Field>' 'is equal to' '<Value>'

For SQL mode:

<FIELD> = '<Value>'

In this example, select fire hydrants manufactured by Clow Corporation.

For Clause mode:

Where 'Manufacturer' 'is equal to' 'Clow Corporation'

For SQL mode:

MANUFACTURER = 'Clow Corporation'

5. Click the Add Clause icon to add an additional clause.
6. Insert the following query to select the second value. In this example, select fire hydrants manufactured by Correy.

For Clause mode:

'Or' 'Manufacturer' 'is equal to' 'Correy'

For SQL mode:

Or MANUFACTURER = 'Correy'

Note: 
Optionally, repeat steps 2e through 2f to select additional values if necessary.

The image below shows the queries configured in this example.

7. Click Run. The values from the queries are selected in the map.

The image below shows the fire hydrants manufactured by Clow Corporation, Correy, and by unknown manufacturers selected from the map.