mysql modified column

(hint: this is why it's ALWAYS a good idea to have a MODIFIED timestamp column on a table that auto-updates when the record updates; because you know the ones already set "N" won't update, so you can take the rest, and flip them back.

http://mcmanus.typepad.com/grind/2006/09/launch_day_is_f.html