You could probably use the one in Sqlite3 as well, rather than a third party one ...
Advertising
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
