Update several field in MySQL

h725 · 09-14-2008, 04:54 AM

Hi,

I've a mysql table with different field, one of these contains a unix path (/usr/home/username).
I must add a string to path (for lot of users) to obtain this:

/usr/home/username/www/

I was thinking about a bash script.. but there is something better ?
Maybe with the mysql "concat" function?

Thanks in advance

h725 · 09-14-2008, 05:08 AM

Sorry, solution was really easy..

update `table` set `field` = concat(`field`,'string');