> On Sep 12, 2017, at 10:52 AM, Richard Hipp <d...@sqlite.org> wrote: > > ... WHERE fl_value(body,'contact.address.state') IN ('CA','WA');
This was just a simple example query. In general it's possible to have arbitrary queries that use arbitrary properties. For example it might be comparing a property to a specific value as well as checking the string's length. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users