Database Question

[Rogue Pan]

What is the SQL Query that i would have to use to delete ALL of 1 users posts at once? I forgot and needed a reminder....


edit: Nevermind just remembered mass pruning in the admincp

[tnguy3n]

DELETE FROM post WHERE userid = XX