mysql - Can I Add SQL QUERY in EXPRESSION MAPFILE? -

can add sql query in expression mapfile ? ..

class name '> 0' expression (select * tb_kelurahan id_kecamatan='[id_kecamatan]' > 0) color 20 215 0 outlinecolor 0 0 0

end # class

no. alternative can add sql additional column data statement , reference in expression.

data "the_geom (select case when id_kecamatan>0 1 else 0 end myexpress, the_geom, ...) foo ...."

and use:

expression ([myexpress] = 1)

HR