exclude row from table if matches criteria?

getdave / grunt-deployments

MYSQL database deployments using GruntJS

MIT License

72 stars 34 forks source link

exclude row from table if matches criteria? #67

Open v3nt opened 9 years ago

v3nt commented 9 years ago

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.