title: Delete specific columns in phpmyadmin
body: <p>I need to delete a list of specific columns here is an example</p>
  
  <p>I have a table that contain "numbers" and "city"</p>
  
  <pre><code>numbers    city
  
  55         madrid  
  55         no  
  56         italia  
  56         no  
  57         paris  
  57         no  
  </code></pre>
  
  <p>I need to keep only "no" city for each number.
  I tried this: </p>
  
  <pre><code>DELETE FROM mytable WHERE numbers (55,56,57) and city (madrid,italia,paris)
  </code></pre>
  
  <p>I know that this will not work but its just for give you an idea of what I need.</p>