This is probably easy, but I can't figure it out, so help will really be appreciated.

I am trying to set all empty last_comment_time field in my table to the same value as image_date (another field). What SQL query do I use?

This didn't work:

Code:
update set last_comment_time = image_date where last_comment_time=0
Thank you all