How to create a trigger to UPDATE this for me when a new record is inserted.
I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column.
UPDATE files SET
fullthumb = CONCAT('http://example.com/thumbs/', thumb);