I figured it out there was 1 more line to change to include all .dds files. Thumbs was the missing link (cover thumbs that is)
Code:
UPDATE movie_info SET coverthumbfullpath = replace(coverthumbfullpath , '.jpg', '.dds') WHERE coverthumbfullpath LIKE '%.jpg%';