[kovidgoyal]

There is an insert link or image button for comment type columns in the metadata editor. See what it does and if you want to automate it, use calibredb to write a script to update the comments accordingly.