title: mysql remove all whitespace at the beginning of string
body: <p>So, I realized that for my db column values, I have a whitespace in front of all strings.</p>
  
  <p>(Couldn't figure out why <code>WHERE name = "Sean"</code> wasn't working and by accident, I noticed that there was a whitespace at the front of the value: <code>WHERE name = " Sean"</code>).</p>
  
  <p>There are some values which a space in between words are needed. </p>
  
  <p>UPDATE (realized that my question was not clear enough).</p>
  
  <p>I am trying to update the db so that the whitespace at the beginning of each string is removed.</p>
  
  <p>Thank you.</p>