This is the SQL query I have used in the past...

Code
update ubbt_PRIVATE_MESSAGE_USERS set MESSAGE_LAST_READ=UNIX_TIMESTAMP() where USER_ID='XXX'


Ian
http://www.firstgenmc.com/ubbthreads

"Experience is a hard teacher because she gives the test first, the lesson afterwords."