On Fri, Mar 21, 2014 at 8:06 PM, Ben Peng <ben....@gmail.com> wrote: > > I guess I will have to take the longer route, namely define a customized > comparison function and translate user input internally. >
There's an also virtual table method, probably not so easy to wrap the head around, but this one allows using comma (or other symbols splitted) lists stored in fields even in joins. See my reply about it at https://www.mail-archive.com/sqlite-users@sqlite.org/msg63453.html. Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users