Is it possible in SQLite to replace once part of a string?
For example
UPDATE pages SET path = replace(path, '/page', '/article') WHERE path LIKE '/page/%'"
results to /page/page1/page2 => /article/article1/article2
but I need /page/page1/page2 => /article/page1/page2
Aucun commentaire:
Enregistrer un commentaire