sqlite3: Can a regular expression be made to work inside a replace function?
I'm trying to do something like so:

select replace(Title, Title REGEXP (\d+\s)+(.*)\2, '') from Books where Title = 'test';

so given two records in Books like '01 01 test' and 'test'

would return 'test' and 'test'.  I have regular expressions working, this just doesn't seem to work.
sqlite3: Can a regular expression be made to work inside a replace function?
===

I'm trying to do something like so:

select replace(Title, Title REGEXP (\d+\s)+(.*)\2, '') from Books where Title = 'test';

so given two records in Books like '01 01 test' and 'test'

would return 'test' and 'test'.  I have regular expressions working, this just doesn't seem to work.