M: Attribute table__Select by attributes

Summarize:

Select features based on an attribute query.

Dialog:

Usage:

•  Query expressions base on NSPredicate.

•  Double click one field name, the field name will be written into the following box.

• =

   •  If the field type is Character type, the strings must always be enclosed within single quotes.

      For example: Field1='European' ⇒ The second feature is selected.

   • If the field type is Integer or Double type.

      For example: Field2=33 ⇒ The third feature is selected.

•  >=

   The field type must be Integer or Double type.

   For example: Field2 >= 22 ⇒ The second, third and fourth features are selected.

•  >

   The field type must be Integer or Double type.

   For example: Field2 > 24 ⇒ The third and fourth features are selected.

•  LIKE

   The field type must be Character type.

   * means that anything is acceptable in its place: one character, a hundred characters, or no character.

   ? means one character is acceptable in its place.

   For example: Field1 LIKE 'As*' ⇒ The first and fourth features are selected.

                         Field1 LIKE 'A?i?*' ⇒ The first and fourth features are selected.

•  <=

   The field type must be Integer or Double type.

   For example: Field2 <= 22 ⇒ The first and second features are selected.

•  <

   The field type must be Integer or Double type.

   For example: Field2 < 22 ⇒ The first feature is selected.

•  !=

   The field type must be Character, Integer or Double type.

   For example: Field1 != 'Asia' ⇒ The second and third features are selected.

                         Field2 != 22 ⇒ The first, third and fourth features are selected.

•  NOT

   •  Use the NOT operator at the beginning of an expression to find features or records that don't match the

      specified expression.

      For example: NOT Field1 = 'Asia' ⇒ The second and third features are selected.

   •  NOT expressions can be combined with AND and OR.

     For example: Field1 = 'Asia' AND NOT Field2=44 ⇒ The first feature is selected.

•  AND

  For example: Field1 != 'Asia' AND Field2=44 ⇒ The fourth feature is selected.

•  OR

  For example: Field1 != 'European' AND Field2=33 ⇒ The second and third features are selected.

•  ''  single quotes