Is This Content Helpful?
We're glad to know this article was helpful.
When using the Select by Attributes tool, query operators such as IN, LIKE, OR, and NOT can be used to determine the type of selection for multiple values. For more information on the query operators types, refer to ArcGIS Help: SQL reference for query expressions used in ArcGIS.
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.
Note: If it is a text field, apply single quotes around each value.
<field name> IN (<field value>, <field value>)
Note: This method can also be used to select numeric and string values.