USE mythconverg

SELECT @var_MOVIEID = `title` FROM `videometadata` WHERE `coverfile` = 'No Cover' LIMIT 1;
SELECT @var_MOVIEID;

SET @var_dir = "/home/james/media/.mythtv/MythVideo/covers/";
SET @var_jpg = ".jpg";
SET @var_MOVIETHUMB = CONCAT(@var_dir, at var_MOVIEID, at var_jpg) ;
SELECT @var_dir, @var_jpg, @var_MOVIETHUMB;

UPDATE `videometadata` SET `coverfile` = @var_MOVIETHUMB WHERE `title` = @var_MOVIEID LIMIT 1 ;