[Resolved] updating a feild with other feild in TABLE

[phpsharma]

HI all,

I have a table with following fields..

id name date_entered date_modified

1 xyz 2005-02-05 21:18:00 2005-02-05 21:18:00
2 abc 2005-02-05 21:18:00 2005-02-06 10:12:00
............................................................
............................................................
3 some name 2005-02-05 21:18:00 2005-05-08 10:12:00

Now i need to update all records with the date_modified field to date_entered .

How can i write sql query?

Thanks in advance

sharma

[edcellgavin]

try this:
update table_name set date_modified = date_entered;

[phpsharma]

Thanks a lot it worked fine