Just started using QGIS and a bit stuck on SQL or filter if anyone can assist please.
Table is labelled “SL” with multiple data columns. “ID” is the column of interest containing 10’s of thousands of location ID’s in the format of LOC00002345, LOC00002346 ..... and so on.
I need to set up an SQL or filter in QGIS that will return only the listed LOC ID’s. The list can vary in size and in the LOC ID’s needed.
Used to use the following in MapInfo but doesn’t work in QGIS.
ID = any("LOC00001234","LOC00001235","LOC00001236”,”LOC00001238”,”LOC00001250”)