Filtering attributes that start with certain text in QGIS Attribute Table

Question

I try to filter for catchwords by using the attribute table. I need to filter all attributes which start with "industrial". The problem is that the attributes are sometimes named "industrialpark", "industrialzone", or "industrialarea".

Is there a way to filter for just a special part of a catchword?

I could imagine that there must be a way to use the "select by expression" tool and say something like "fieldname = 'indust...'" or "fieldname = 'industrial...'" , so that QGIS prints out all catchwords which start with the searched part of the word.

Answer 1

For a general expression to be used wherever you want, try

"fieldname" LIKE 'industrial%'

where the % wildcard matches any or no character following the string.