MySQL UPDATE append data into column

November 30, 2023 by Tarik

Try this Query:

update tablename set col1name = concat(ifnull(col1name,""), 'a,b,c');

Refer this sql fiddle demo.