The webhost for that videos on my small wordpress blog transformed possession and knowning that made the decision to alter the embed codes. Now there's 'some' comformity so far as keeping exactly the same video amounts exactly the same, however now will need to go through 200+ posts and alter the initial embed code to now match the brand new one (at this time all of the videos aren't effective until I actually do so).

Case my best guess, so please correct me if you have a much better one, however i figure the simplest way is always to use SQL, however i am scared of playing up. What will be the best sql command to alter every demonstration of

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" width="416" height="234" id="mbox_player_7c99dfb41b1fe6c7f4"><param name="movie" value="http://www.motionbox.com/external/hd_player/type%253Dsd%252Caffiliate_name%253Dpro%252Cvideo_uid%253D7c99dfb41b1fe6c7f4" /><param name="allowScriptAccess" value="always" /><param name="allowFullscreen" value="true" /><embed src="http://www.motionbox.com/external/hd_player/type%253Dsd%252Caffiliate_name%253Dpro%252Cvideo_uid%253D7c99dfb41b1fe6c7f4" type="application/x-shockwave-flash" pluginspage="http://www.adobe.com/go/getflashplayer" width="416" height="234" allowFullscreen="true" allowScriptAccess="always" name="mbox_player_7c99dfb41b1fe6c7f4"></embed></object>

with

<object id="video-7c99dfb41b1fe6c7f4" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="416" height="234"><param name="movie" value="http://www.sproutvideo.com/flash/MediaPlayer.swf" /><param name="allowScriptAccess" value="always"><param name="allowFullscreen" value="true"><param name="flashvars" value="id=7c99dfb41b1fe6c7f4&st=170e02740ae12cde&type=sd"><!--[if !IE]>--><object type="application/x-shockwave-flash" allowScriptAccess="always" allowFullscreen="true" data="http://www.sproutvideo.com/flash/MediaPlayer.swf" width="416" height="234" flashvars="id=7c99dfb41b1fe6c7f4&st=170e02740ae12cde&type=sd"><!--<![endif]--><p>Please install Adobe Flash to watch this video. <a href="http://www.adobe.com/go/getflashplayer/"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></p><!--[if !IE]>--></object><!--<![endif]--></object>

?? Spot the object id + classid's are identical (thats the particular video #). I have downloaded a nearby version and also have done only royally mess some misconception within the last week, otherwise i wouldn't have requested on here. Thanks