Update+Media+Paths

I have recently added a new drive to my pc and wanted a quick way to update the media path file. Whilst there is standard tool within RM5 to fix broken media links, it searches through my entire pc which now has 5TB of data - it picks up files from backup directories and generally takes a long time. I also have the option to update the path directly in the MultimediaTable. Some examples below:

code SELECT * FROM MultimediaTable WHERE Mediapath like ('J\FAMILY_HISTORY\PAXTON\CERT%'); code
 * I want to review the records with a particular path
 * I want to update this path to the new path

code UPDATE multimediatable SET Mediapath = 'S:\New_Family_History\PAXTON\CERT\') WHERE mediapath LIKE ('J\FAMILY_HISTORY\PAXTON\CERT%'); code


 * If i want to replace only some of the path and not the entire string i use the REPLACE function

code UPDATE multimediatable SET Mediapath = REPLACE (Mediapath, 'J\FAMILY_HISTORY\', 'S:\New_Family_History\') WHERE mediapath LIKE ('J\FAMILY_HISTORY\PAXTON\CERT%'); code

Cheers,

Sean