title: MySQL add prefix to table - WHERE syntax trouble
body: <p>I am trying to add a prefix <code>myprefix_</code> to MySQL table named <code>post</code>. I got stuck in one place:</p>
  
  <pre><code>DELETE FROM `post` WHERE `post`.`post_id` = ? 
  </code></pre>
  
  <hr>
  
  <p>I added <code>myprefix_</code> here:</p>
  
  <pre><code>DELETE FROM `myprefix_post`
  </code></pre>
  
  <p>but what about second part?</p>
  
  <pre><code>WHERE `post`.`post_id` = ? 
  </code></pre>
  
  <p>Should I change it to this?</p>
  
  <pre><code>WHERE `myprefix_post`.`post_id` = ? 
  </code></pre>
  
  <hr>
  
  <p>W3Schools <a href="https://www.w3schools.com/sql/sql_where.asp" rel="nofollow noreferrer">LINK</a> gives an information that the syntax looks like this and I'm lost, because "post" is current table name:</p>
  
  <pre><code>FROM table_name WHERE condition;
  </code></pre>