Q:I want to mass delete my trash with 2000+ Posts in it. Is there a mysql command to do so?
A: Please backup before running the query, i’ll not take responsibility if something goes wrong as a result..
FROM wp_posts p
LEFT OUTER JOIN wp_postmeta pm ON (p.ID = pm.post_id)
WHERE post_status = ‘trash’
Join is optional, removes entries from the meta table (if they exist).
Check your data base table prefix also, if it is not wp_, you have to change it to your table prefix.
Tested under MySQL 5.1 in Phpmyadmin.