On 3/9/2014 6:37 PM, Tim Streater wrote:
Dammit, I looked up and down for 'strlen' and passed over 'length'! I had been thinking about:update mytable set path='/path/from/' || substr(path, length('/path/to/') + 1) where path like '/path/to/%'; that way I anchor to the start of the path.
Be careful about '/path/to/' itself containing percent signs or underscores. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
