samedi 11 avril 2015

SQLite - replace once part of a string

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