adding a string to data already in the database

[coolispaul]

Hi

does anybody know if there is a function that i can use to prepend a string to data in every row of a particular field in the database.

The problem i have is that i have a field called 'images' which contains the name of the image. However, i need to put the path to it before the name. So just want to add the path in to every row.

Thanks

[fenway]

Try the following:

[code]UPDATE yourTable SET col1 = CONCAT('string to prepend',col1);[/code]

Hope that helps.