> On May 10, 2018, at 10:27 AM, Stephen Chrzanowski <[email protected]> wrote:
>
> select * from SomeComments where Comment like 'Beginning%|%End'
Don’t try to reinvent regular expressions! If you add a SQLite extension that
defines a regexp() function, such as this one (which I’ve never used)
https://github.com/eatnumber1/sqlite-regexp
<https://github.com/eatnumber1/sqlite-regexp>
then you can write that query as:
select * from SomeComments where Comment regexp '(^Beginning)|(End$)'
(Apologies if I’m misremembering my regex syntax!)
—Jens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
