ALTER TABLE `mm_Classified` ADD `startDate` DATE NOT NULL AFTER `price`, ADD INDEX (`startDate`) ; UPDATE `mm_Classified` SET `startDate` = `added` WHERE `startDate` = '0000-00-00';