How to clear a single user's history?

[wholemama]

I see how to do it for everyone...is there a way to clear a single person, either through the front end or the DB?

And deleting all rows with their userid from vbp_itemhistory doesn't work, already tried that.

[CMX_CMGSCCC]

Try running a query like...


UPDATE (TABLE_PREFIX)user SET vbp_history = '' WHERE userid = X;


-CMX