mercredi 9 septembre 2015

SQL (lite) replace string value in all columns with formatting

I'm trying to update a SQLite database with a column "URL" with a specific value. The old url format is "http://ift.tt/1Lk7FxB" and the new one is "http://ift.tt/1iwTA9e".

What I am trying to do is replace the url to the new format but keep the value of the 'Q' param from the old url. What is the fastest / best way to achieve this for all columns? I have no idea how to approach this using an SQL query.

Aucun commentaire:

Enregistrer un commentaire