You could probably use the one in Sqlite3 as well, rather than a third party 
one ...

https://www.sqlite.org/src/artifact/a68d25c659bd2d89


---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.


>-----Original Message-----
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke
>Sent: Thursday, 10 May, 2018 12:54
>To: SQLite mailing list
>Subject: Re: [sqlite] OR statement in LIKE
>
>
>
>> On May 10, 2018, at 10:27 AM, Stephen Chrzanowski
><pontia...@gmail.com> 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
>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

Reply via email to