title: Wordpress Mysql Delete post if title contains
body: <p>I want to delete all of my wordpress posts, which contains specific keywords. In regex it would be:</p>
  
  <pre><code>.+\((S\d+E\d+)\)
  </code></pre>
  
  <p>for example it would delete:</p>
  
  <pre><code>"Post blabla (S01E02)"
  "1231 How to do it (S55E02)
  "(S05E72)"
  </code></pre>
  
  <p>But i dont know how to use regexp in mysql properly. Can you help me with that. I think, something like this would be good:</p>
  
  <pre><code>SELECT * FROM 'wp_posts';
  WHERE 'post_title' REGEXP '__i dont know what to put there__';
  </code></pre>