title: How do I remove all spaces from a field in a mysql database in an update query?
body: <p>What would be the proper syntax used to  run an update query on a table to remove all spaces from the values in a column?</p>
  
  <p>I have a user table that had user names with spaces imported into it &amp; I need to remove the spaces. i.e. "john smith sr." needs to be "johnsmithsr." </p>
  
  <p>there are about 500+ occurrences. </p>