title: How to update an SQLite database with a search and replace query?
body: <p>My SQL knowledge is very limited, specially about SQLite, although I believe this is will be some sort of generic query... Or maybe not because of the search and replace...</p>
  
  <p>I have this music database in SQLite that has various fields of course but the important ones here the "media_item_id" and "content_url".</p>
  
  <p>Here's an example of a "content_url":</p>
  
  <pre><code>file:///c:/users/nazgulled/music/band%20albums/devildriver/%5b2003%5d%20devildriver/08%20-%20what%20does%20it%20take%20(to%20be%20a%20man).mp3
  </code></pre>
  
  <p>I'm looking for a query that will search for entries like those, where "content_url" follows that pattern and replace it (the "content_url") with something else.</p>
  
  <p>For instance, a generic "content_url" can be this:</p>
  
  <pre><code>file:///c:/users/nazgulled/music/band%20albums/BAND_NAME/ALBUM_NAME/SONG_NAME.mp3
  </code></pre>
  
  <p>And I want to replace all these entries with:</p>
  
  <pre><code>file:///c:/users/nazgulled/music/bands/studio%20albums/BAND_NAME/ALBUM_NAME/SONG_NAME.mp3
  </code></pre>
  
  <p>How can I do it in one query?</p>
  
  <p>P.S: I'm using Firefox SQLite Manager (couldn't find a better and free alternative for Windows).</p>