title: Cannot delete record from MySQL. Error says column does not exist, when it clearly does
body: <p>This is very strange.. </p>
  
  <p>I'm using PHPMyAdmin to view a table. [edit: Does the exact same thing in SQLYog.] I select one of the records in that table, and click "Delete".  I then get an error saying that the column (in this case "users_id" which is an auto-increment primary key) does not exist.  Yet.. when I run a select query for that same info, it returns the record fine.</p>
  
  <p>So, here's the SELECT query I'm using that finds the record perfectly:</p>
  
  <pre><code>select * from users where users_id = 53
  </code></pre>
  
  <p>No quotes, nothing.  And it returns the record with no problem.  I would show you in a screen capture, but even though I have the reputation, the system isn't allowing me to post images. (ugh)</p>
  
  <p>However, do this either by clicking "Delete" and "GO", or by entering SQL directly:</p>
  
  <pre><code>delete from users where users_id = 53
  </code></pre>
  
  <p>.. and you get an error:</p>
  
  <pre><code>Error
  SQL query:
  
  DELETE FROM `goat-dev`.`users` WHERE `users`.`users_id` =53
  
  MySQL said: Documentation
  #1054 - Unknown column 'users_id' in 'where clause' 
  </code></pre>
  
  <p>So clearly something is off... and I just don't see what.  Any suggestions?</p>
  
  <p>I'm logged in as "root" with full permissions.  I've quadruple-checked to be sure I have no limits on my permissions (not sure how root could).</p>