Reply to thread

Message

<blockquote data-quote="Slurm" data-source="post: 548436" data-attributes="member: 27798">I took a short look at SQLite Database Browser because I wasn't sure if it could do so and I think SQLite Expert is way easier to handle and more comfortable (and it's free as personal edition).You're absolutly right: The best way is to use the movingpictures configuration for changes and not directly the database, but it seems to work too.And here's a very handy query I sometimes use for search and replace:update local_media set fullpath = &quot;D:\Movies&quot; || substr(fullpath,length(&quot;C:\Movies&quot;) +1,999) where fullpath like &quot;C:\Movies%&quot;;This replaces all occurences of 'C:\Movies' with 'D:\Movies' if you move your movie collection from one drive to another or change drive letters (of course you have to update your import path too, and if you have different media_label and volume_serial for the new path they have to be updated the same way too).Another nice query is the following: update movie_info set genres = replace(genres, 'Comedy', 'Komoedie');I get data for my movies from different sources (imdb, ofdb, ...) and the genres are also different there. This query replaces the english word 'Comedy' with the german word 'Komoedie' for all entries so I have only one entry for the same genre and not two in two different languages.</blockquote>

[QUOTE="Slurm, post: 548436, member: 27798"] I took a short look at SQLite Database Browser because I wasn't sure if it could do so and I think SQLite Expert is way easier to handle and more comfortable (and it's free as personal edition). You're absolutly right: The best way is to use the movingpictures configuration for changes and not directly the database, but it seems to work too. And here's a very handy query I sometimes use for search and replace: [B]update local_media set fullpath = "D:\Movies" || substr(fullpath,length("C:\Movies") +1,999) where fullpath like "C:\Movies%";[/B] This replaces all occurences of 'C:\Movies' with 'D:\Movies' if you move your movie collection from one drive to another or change drive letters (of course you have to update your import path too, and if you have different media_label and volume_serial for the new path they have to be updated the same way too). Another nice query is the following: [B]update movie_info set genres = replace(genres, 'Comedy', 'Komoedie');[/B] I get data for my movies from different sources (imdb, ofdb, ...) and the genres are also different there. This query replaces the english word 'Comedy' with the german word 'Komoedie' for all entries so I have only one entry for the same genre and not two in two different languages. [/QUOTE]

Verification