My goal is to select all of the features in a layer with certain names.
I have a list of 86 Subdivision names and a I am using a county Subdivision dataset, the names in the dataset include the subdivision names but also some text before and after the name (i,e. REPLAT, and PLAT 1, etc).
I created an expression to return the names from my list but it is displaying the following parser errors in QGIS (my query is displayed in the image as well).
Query text (sample):
SELECT * FROM 'SUBDIVISION_POLYGON_614b57b6_a27b_4aaa_973c_aa7da31cedd6' WHERE "PLAT_NAME1" = 'austinbrooke acres%' OR '%austintown park%' OR '%beverly hill%' OR '%bridget heights%' OR '%broadview%' OR '%burgess run heights%' OR '%candywoods estates%' OR...
What do these errors mean? Can this work or is another approach better?