enter image description here

"name" like 'column%'

Output preview: 0


"name" = 'column_title'

Output preview: 0

No filtering results in expression. Tried Qgis 2.12 and 2.18 both on OS X. Data is from Open Street Map - geofabrik supplier.

  • 1
    Did you also click "select"? The preview at the bottom shows the result for a random line in the dataset and not the amount of filtered features. Commented Nov 14, 2016 at 9:02
  • In your picture you have as recent selection like 'Trunk%' and your value in the table is 'trunk'. Keep in mind that SQL is case sensitive. Use Qgis ILIKE-Operator or lower("highway") to avoid it. And also what you mean by "name" = 'column_title' and like 'column%' ? It sounds like you want to filter for a column-names, but you can only filter for row-values.
    – Matte
    Commented Nov 14, 2016 at 9:10

1 Answer 1


Output preview is just telling you the result of your expression applied to the first record. A 0 just means it is false for that record.

If you go ahead and press select you will actually apply the filter to all of your records.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.