The following workflow uses the IN query operator to select multiple values. This workflow is also applicable to the other query operators; LIKE, OR, and NOT.
-
In ArcMap, open the attribute table of the layer.
-
Click the
Table Options
button
>
Select By Attributes
.
-
Double-click the field containing the desired values.
-
Add a space after the field name and type
IN.
-
Select the parentheses icon.
-
In the parentheses, select or type the values. Separate each value with a comma.
Note:
If it is a text field, apply single quotes around each value.
The following is a sample query:
<field name> IN (<field value>, <field value>)
-
Click
Apply
.
Note:
This method can also be used to select numeric and string values.