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 <[email protected]> wrote: > On 9 Oct 2018, at 2:47pm, Leonardo Inácio de Freitas < > [email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
