GOAL: I'm trying to filter all the 1's in a spatial boolean operation in Qspatialite, the spatialite plugin for QGIS.
ATTEMPTED SOLUTION: My solution is to perform the boolean query first, export the resulting table AS a table second, then query THAT table for all the 1's, third.
PROB W/ SOLUTION: Problem is, column to be filtered has a header that is in itself a function (i.e., "within(geom 1, geom 2)"). Thus, the header cannot be called in the command dialog as a simple string, because it inevitably becomes a command/function.
This is what I ran:
SELECT Towns.name, Schools.name, within(Schools.geom, Towns.geom) from Towns, Schools
within(Schools.geom,Towns.geom) becomes the table header, which I need to filter for 1s.