> On Oct 9, 2018, at 6:47 AM, Leonardo Inácio de Freitas > <oldbrain...@gmail.com> wrote: > > Using SQLite, can you use masks (or regex) (like '% str%') inside > instr / substr, to delimit the output of a select, instead of me > determining the beginning and end of the substring?
You could implement a custom query function to do this (custom functions are quite simple, and there are examples online). Or you could just postprocess the string in your application code when it comes back from the query. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users