MYSQL Query can select records where inserted date equal to updated date from a datetime field

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

possible dupe of [this](http://stackoverflow.com/questions/9032047/datetime-mysql-select-only-date) — James, May 22 '14 at 22:37

score 2 · Accepted Answer · edited May 22 '14 at 23:07

2

date() cuts time leaving only date

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

edited May 22 '14 at 23:07

M.M

answered May 22 '14 at 22:34

Horaciux

Thank you dear it worked perfectly more then my way because I I tried ( UPDATE `realty` SET `modifier` = `creator` WHERE `updated` between `created` AND `created` + INTERVAL 23 HOUR ) – M.M May 22 '14 at 23:00

1 Answers1