Can you post the table definition of the table (telling which field needs to be updated)? I'll be able to give you the query then.

Also I meant this in my previous post :

then I would put an on insert/update TRIGGER and run the same query for that column.