[sqlite] How to perform regex on string

Have you looked at https://www.sqlite.org/src/artifact/af92cdaa5058fcec ? Simon wrote: | | Do you have to use regexp ? The following works: | | sqlite> SELECT replace('The time is %s.', '%s', strftime('%s','now')); | The time is 1437054006. | | | On 15 Jul 2015, Rick asked: | > | > Is there a

[sqlite] How to perform regex on string

On 15 Jul 2015, at 1:53pm, Rick wrote: > Is there a simple way to replace portions of a string using the regex > function of sqlite without actually accessing any specific DB entres. > > Similar to > > SELECT strftime('%s','now') as unixtimestamp Do you have to use regexp ? The following

[sqlite] How to perform regex on string

Is there a simple way to replace portions of a string using the regex function of sqlite without actually accessing any specific DB entres. Similar to SELECT strftime('%s','now') as unixtimestamp what just returns the result in unixtimestamp... just that I need to perform regex on a normal