title: MYSQL, update only certain rows of a table which satisfy certain conditons
body: <p>This is wordpress database.It has two tables <code>wp_terms</code> and <code>wp_term_taxonomy</code></p>
  
  <pre><code>wp_terms has columns slug, name, term_id
  wp_term_taxonomy has columns term_id, taxonomy, term_taxonomy_id.
  </code></pre>
  
  <p>Now I try</p>
  
  <pre><code>UPDATE wp_terms
  SET slug = CONCAT(slug,'-quotes')
  FROM wp_terms, wp_term_taxonomy
  WHERE wp_term_taxonomy.taxonomy = "post_tag" AND wp_term_taxonomy.term_id = wp_terms.term_id 
  </code></pre>
  
  <p>I am trying to concat the word in the rows of the column "slug" of table "wp_terms" which satisfy certain conditions. </p>
  
  <p>but mysql gives</p>
  
  <blockquote>
    <p>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wp_terms, wp_term_taxonomy
        WHERE wp_term_taxonomy.taxonomy = &quot;post_tag&quot; AN' at line 3 </p>
  </blockquote>