exclude row from table if matches criteria?

[v3nt]

A simple way to exclude table rows from certain tables?

ie. SELECT * FROM wp_posts WHERE post_type LIKE '%revision%'

I've been using this across several sites over the last year and some databases are 100mb+ so being able to exclude 'padding' or unwanted data would save a lot of time and space.