If a column has several rows, i.g.:<\/p>\n\n\n\n
'red' \n'NULL' \n'red, yellow' \n'green' \n'NULL' \n'yellow, green'\n<\/pre>\n\n\n\nAnd you want to add a new string (\u2018blue\u2019) to every row, so that the result be:<\/p>\n\n\n\n
'red, blue' \n'blue' \n'red, yellow, blue' \n'green, blue' \n'blue' \n'yellow, green, blue'\n<\/pre>\n\n\n\nyou can use this code<\/p>\n\n\n\n
UPDATE my_table \nSET mycolumn = CONCAT('same new string ',mycolumn); <\/pre>\n\n\n\nBut the above code works only for rows with some content, not for the empty (NULL) ones. Therefore you can complete your task with the following:<\/p>\n\n\n\n
UPDATE my_table \nSET mycolumn = 'same new string' \nWHERE mycolumn IS NULL; <\/pre>\n","protected":false},"excerpt":{"rendered":"If a column has several rows, i.g.: ‘red’ ‘NULL’ ‘red, yellow’ ‘green’ ‘NULL’ ‘yellow, green’ And you want to add a new string (\u2018blue\u2019) to every row, so that the result be: ‘red, blue’ ‘blue’ ‘red, yellow, blue’ ‘green, blue’ ‘blue’ ‘yellow, green, blue’ you can use this code UPDATE my_table SET mycolumn = CONCAT(‘same … <\/p>\n