Understanding the REPLACE Command in MySQL July 13, 2018 At times, it is necessary to replace full or partial value in a column. The following command will be handy in achieving the this result. UPDATE TABLE_NAME SET COLUMN_NAME =