MySQL question: Inserting column with URL info

[d3funct]

I have defined a column in my database called "url" which will contain the URL of the file named in the second column of this same database. Since this database consists of 8,000 rows of four columns (filesize, modified date, filename, url), how can I script something to choose the text under column "filename" and append it to a line like "

http://intranet.myjob.com/serverdocs/"

and insert that line under the "url" column?

Hope this isn't too confusing, any questions, let me know. Thanks for any and all suggestions.

d3funct
zimmer.jon@cfwy.com
The software required `Windows 95 or better', so I installed Linux.