Restore Users Posts Query

[Digital Jedi]

Let me make sure this is the right query to run. I want to restore some deleted users posts with their current accounts. I found this query at vB.com:

PHP Code:

UPDATE post SET userid='xxx' WHERE username='Old Name'; 


And, of course, I get an error.

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table '*********_cogonline.post' doesn't exist

So, do I need to add a prefix to post, such as the ones my tables use? Like, say, vb_post or whatever my tables use? Or did I do this wrong from the start?