XF 1.2 How To Find A Post In Database by Searching User ID?

[DRE]

What's an sql query for pulling up a xf_post in the database only by posting the user id?

Would it be:

SELECT * FROM xf_post WHERE user_id = "xxx"

 

[MattW]

That will pull up ALL posts by that user ID