SELECT SUBSTR(j.value, 8,1) AS jnum,
         d.data               AS name
    FROM settings AS j,
         settings AS d
   WHERE d.value = CONCAT("UserJobDesc", SUBSTR(j.value, 8,1))
         AND LENGTH(IFNULL(j.data, "")) > 0
         AND j.value LIKE "UserJob_"
ORDER BY jnum



jnum    name
1       move_to_nas
2       move_to_movie