[GIS] QGIS select features from attribute table using the “LIKE” operator

attribute-tableqgisselect-by-attribute

I created an expression with the help of the GUI in the QGIS attribute table of a vector (shapefile) layer of Native American ("Indian") reservations in the USA state of New Mexico.

"NAME" LIKE 'Picuris'

No row became selected.

The full "NAME" in the desired row is 'Picuris Indian Reservation' . I don't mind typing the whole name, but in principle, is not the LIKE function supposed to find partial matches? That is, if I want 'State Hwy 68' (which is in the FULLNAME field) (of a different layer), will the LIKE operator not find it if I use "FULLNAME" LIKE 'Hwy 68' ?

Best Answer

You can also use the column filter of the attribute table. It works default as a 'like' expression without the % wild card.

enter image description here

Result when typing a:

enter image description here

Related Solutions

[GIS] Select all “NULL” values in the attribute table

Without knowing what your data looks like, the general syntax you need to insert into the select by attributes window is:

[FIELD_1] IS NULL OR [FIELD_2] IS NULL OR [FIELD_3] IS NULL

and so on for as many fields as you have to work with. For reference the full query would be:

SELECT * FROM [TABLE_NAME] WHERE [FIELD_1] IS NULL OR [FIELD_2] IS NULL OR [FIELD_3] IS NULL

[GIS] Select features using an expression, QGIS

There are two possibilities when you want to select several value.

The first is to use the OR operator :

"Parametro" = 'alfa-Hexaclorociclohexano' OR "Parametro" = 'beta-Hexaclorociclohexano' OR "Parametro" = 'delta-Hexaclorociclohexano' OR "Parametro" = 'gamma-Hexaclorociclohexano'

You need to repeat the field name each time (this also work if you want to use several field)

The second is to use the IN operator :

"Parametro" IN ('alfa-Hexaclorociclohexano','beta-Hexaclorociclohexano','delta-Hexaclorociclohexano','gamma-Hexaclorociclohexano')

Work only for one field but easier to read and type (of course if you need two or more field you can join several with AND or OR...)

Best Answer

Related Solutions

[GIS] Select all “NULL” values in the attribute table

[GIS] Select features using an expression, QGIS

Related Question