title: How to delete rows in MySQL with specific text
body: <p><a href="https://i.stack.imgur.com/JTldt.png" rel="nofollow noreferrer">Table Image</a></p>
  <p>Hello! I'm trying to delete some rows within my file where the State_Name is United States and District of Columbia.</p>
  <p>The database names I put as zzz_schema &gt; Tables &gt; 2017_annual</p>
  <p>I've tried the delete from command but unfortunately with no luck. my code reads as below:</p>
  <pre><code>SELECT *
  FROM zzz_schema.2017_annual
  WHERE Measure_Name = 'Food Insecurity'
  DELETE FROM 2017_annual WHERE State_Name = 'United States'
  </code></pre>
  <p>The first three lines gives me the correct table (attached as the picture) but I'm having trouble with deleting that specific stuff.</p>
  <p>Thank you.</p>