update date column in mysql

update `myDb`.`myTable` set myColumn = (DATE_SUB(sysdate(), INTERVAL 1 DAY));