English

How To: Select multiple values using the Select By Attributes tool

Summary

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.

Procedure

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.

  1. In ArcMap, open the attribute table of the layer.
  2. Click the Table Options button The Table Options button > Select By Attributes.
  3. Double-click the field that contains the desired values.
  4. Add a space after the field name and type IN.
  5. Select the parentheses icon.

    Screenshot of Select by Attributes with the parenthese highlighted.
     
  6. In the parentheses, select or type the desired values. Separate each value with a comma.
Note:
If it is a text field, apply single quotes around each value.
Screenshot of Select by Attributes with values added.
 
The following is an example of the query:
<field name> IN (<field value>, <field value>)
  1. Click Apply.
Note:
This method can also be used to select numeric and string values.

Related Information