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

But I ran into the IUNICODE problem as described in http://www.mediamonkey.com/forum/viewtopic.php?t=16897&highlight=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/viewtopic.php?t=24841&sid=e430efd0e8ff03a8a71b0ffc6d1a294a

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

[b]1)[/b] 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 ??

[b]2)[/b] What is the substring-like command line syntax to change all references of "[b]\\PC01\"[/b] to"[b]C:\[/b]"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