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 string and return the result as a new string. Probably something like (logics wise) SELECT replace('#</*\w+:\w[^>]*+>#i', '', string_to_modify) as result Sorry if this sounds like a stupid questions... but totally new to sqlite and its possibilities. Rick