MYSQL Query可以从datetime字段中选择插入日期等于更新日期的记录

Question

before any thing I would like to thank you here is my problem

I want to write MYSQL query that select the records where insert date equal to modified date from a datetime field and ignore the time.

I tried

UPDATErealty SET modifier = creator WHERE created = updated;

but it worked with the records that was modified in the same time and I want it to ignore the time

Answer 1

date() cuts time leaving only date

UPDATE realty SET `modifier` = `creator` WHERE date(`created`) = date(`updated`);