2016-01-29 10:20 GMT+01:00 Richard Hipp <drh at sqlite.org>:
> On 1/29/16, Cecil Westerhof <cldwesterhof at gmail.com> wrote:
> > In h2 I can search for words with:
> > quote REGEXP CONCAT('(\W|^)', :search_string, '(\W|$)')
> >
> > Is something like that also possible with SQLite?
>
> SQLite does not have a REGEXP operator enabled by default. However,
> if you add the (https://www.sqlite.org/src/artifact/af92cdaa5058fcec)
> extension to your build, then REGEXP will be available and you can do:
>
> ... quote REGEXP ('\b'||:search_string||'\b);
>
> Or you could use Full Text Search (https://www.sqlite.org/fts3.html)
> which is built-in by default.
>
?That looks interesting. I am going to look into that.
--
Cecil Westerhof
