I've a table with 2 columns (word and meaning). word column contains same entry in many rows so I want to make them together. This following query gives me good result but I can't update my table. SELECT word, group_concat(meaning, '/') as meaning FROM Table1 GROUP BY word; This works for me. But the thing is I can't update it to my table.