QGIS Select Features – How to Select Features Containing Specific Text String

expressionfeaturesqgisselect

I need to style a survey parcel polygon shapefile, based on whether the polygon is a mineral claim or not. Unfortunately, the only information on whether a polygon is a mineral claim or not is contained in the "TITLE" field of the attribute table, which gives the full legal name of the surveyed parcel.
For instance, 'DISTRICT LOT 5639, BEING AWARD NO. 2 MINERAL CLAIM, KDYD'.
I need an expression that selects any feature containing the text 'MINERAL CLAIM' in the "TITLE" field.

Best Answer

You just gotta use the LIKE operator.

For example, "TITLE" LIKE '%MINERAL CLAIM%'

The % symbol acts like a wildcard.

LIKE is case-sensitive, whereas ILIKE is not.

Related Question