well... It's not quite that categorical "no", although Simon's more than correct.
There's extensions that allow for regexp(), such as you might find in SQLite Studio that allow for some really handy cross-functionality when paired with group_concat(), for example. (It's addictive to have it handy during development, in fact.) I understand that it can be rolled into your own local build, if you want to use it, but it complicates things in terms of portability. If you craft your SQL around that...you need to bring that build along with it, and any headaches that it might include. Otherwise, you'd want to leverage your application's handling to emulate the same behavior. Regards. Brian P Curley On Tue, Oct 9, 2018 at 10:04 AM Simon Slavin <slav...@bigfraud.org> wrote: > On 9 Oct 2018, at 2:47pm, 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? > > No. Sorry. You have to use string core functions to isolate the piece > you want: > > <https://www.sqlite.org/lang_corefunc.html#substr> > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
