Concatenating in a table column
I am using Mysql
I have a column A which contains about 2000 imagenames eg "myimage.jpg"
I have a Column B
I want to copy the phrase imagedirectory/ plus the imagenames into colum B.
So the finished entry in Column B will read imagedirectory/myimage.jpg
I wondered if there is a way of doing this in a table column rather than in a view or query?
Many thanks
John