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.
--
D. Richard Hipp
drh at sqlite.org
