title: MySQL delete selected rows from table
body: <p>Ok so I am a bit stumped. I am horrible with the command line. I have a Database with a table "wp_postmeta" that has 2 million extra/empty entries. These got there from a malfunctioning plugin. I am using SSH to access my db and this <code>SQL</code> query does not seem to work. I am trying to delete only the entries that have a <code>meta_key</code> value that starts with <code>'_oembed'</code>. Here is what I used:</p>
  
  <pre><code>DELETE * FROM wp_postmeta WHERE meta_key LIKE  ('%_oembed%');
  </code></pre>
  
  <p>Am I missing something?</p>