"GNR" is a string column and I expect the filter expression
"GNR"='.11' to only return the feature with the value
Why are the other features with values of
Is there something wrong with my query?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
There is nothing wrong with your query.
= is a comparison operator and it returns all the records which begins with your string
Use this instead:
"GNR" LIKE '.11'
When you compare alphabetic characters, use
QGIS 2.0.1 or newer you can use regular expressions, also:
^indicates the start of the string;
$indicates the end of the string.
I would like to ask, what is the string for use filter by 2 (or more) attributes - for example town and city:
"type" LIKE '%(town+city)%' or "type" IS '(town+city)'
Is not working.