title: How to update one value in mysql table without updating the entire column
body: <p>I'm trying to update one value in a MySql table using Java but my code updates the entire column in which the specified value is included.</p>
  
  <p>I've tried using the LIMIT feature like</p>
  
  <pre><code>String sql = "UPDATE Task SET Status=? WHERE deadline = ? and name = ? order by deadline LIMIT 1";
  </code></pre>
  
  <p>but the program still updates the entire 'status' column not just one value. I've also tried adding 2 specifications using <code>WHERE</code> but it still doesn't work.</p>
  
  <p>There's no error message.</p>
  
  <p>Help? Thanks!!</p>