[sqlite] Searching for words

2016-01-29 10:20 GMT+01:00 Richard Hipp : > On 1/29/16, Cecil Westerhof 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 def

[sqlite] Searching for words

In h2 I can search for words with: quote REGEXP CONCAT('(\W|^)', :search_string, '(\W|$)') Is something like that also possible with SQLite? -- Cecil Westerhof

[sqlite] Searching for words

On 1/29/16, Cecil Westerhof 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/s