Simple SQlite commands

[mp3_monkey]

For a database called TEST.DB, and a table called SONGS :

1) What is the command line syntax to change all values in the column IDMedia to 47? Is it something like
REPLACE TEST.SONGS.[IDMedia] WITH 47 ??

2) What is the substring-like command line syntax to change all references of "\\PC01\" to"C:\"in the column SongPath. Ie end produvt would be
FROM: \\PC01\Users\Public\Music\Library\Abba\Chiquitita.flac to
TO: C:\Users\Public\Music\Library\Abba\Chiquitita.flac

[mp3_monkey]

okay - figured it out - UPDATE Songs SET IDMedia ='47'

But I ran into the IUNICODE problem as described in http://www.mediamonkey.com/forum/viewto ... ht=unicode so I guess thats a brick wall for now, ie cannot make changes to the database using external editors.

However, it appears a workaround may be here:
http://www.mediamonkey.com/forum/viewto ... fc6d1a294a