[ACCEPTED]-How to update an SQLite database with a search and replace query?-replace

Accepted answer

Score: 62

You are probably looking for the replace function.

For 1 example,

update table_name set 
  content_url = replace(content_url, 'band%20albums', 'bands/studio%20albums')
where
  content_url like '%nazgulled/music/band_20albums/%';

More documentation at http://sqlite.org/lang_corefunc.html

Source: stackoverflow.com

More Related questions

Cross-table UPDATE in SQLITE3

SQLite inner join - update using values from another table

UPDATE syntax in SQLite

SQLite - Create Trigger for Insert or Update

CASE vs Multiple UPDATE queries for large data sets - Performance

How to update a part of a timestamp field in postgres?

Update Table with a "Select query" with a where clause

How to copy text column value from one row to another row in mySQL

MySQL: Update all rows in a table matching results of another query

EntityFramework, Insert if not exist, otherwise update

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.