title: How can I update the boolean values in mysql?
body: <p>My table has an <code>isSuccessful</code> column, I set the datatype as boolean (0 indicates false, 1 indicates true), and by default is 0. </p>
  
  <p>But when I want to update this column using php, </p>
  
  <pre><code>UPDATE .......... SET isSuccessful = 1 WHERE .........
  </code></pre>
  
  <p>it doesn't work.</p>
  
  <p>I tried to set the <code>isSuccessful</code> as 1, true, yes, but none of them will work.</p>
  
  <p>So how can I change the values of <code>isSuccessful</code>?</p>