In a SQL table I have two columns: the first contain a path and the second contains a value.
You have to use CONCAT
update tablename p set p.colunm1 = CONCAT("/path/",`colunm2`,"/");
548k questions
547k answers
4 comments
86.3k users