title: Remove space between two words in MySQL
body: <p>Consider the following example messages in my database:</p>
  
  <pre><code>I dont agree with you
  That is something I dont do
  This is another string with dont
  String without d o n t
  </code></pre>
  
  <p>Whenever a message has the string " dont" in it, I want to remove the space after it so that it becomes one term with the following word:</p>
  
  <pre><code>I dontagree with you
  That is something I dontdo
  This is another string with dont
  String without d o n t
  </code></pre>
  
  <p>I have thousands of these kinds of messages in my database. I could query the database in PHP, and then perform a</p>
  
  <pre><code>$message = str_replace(' dont ', ' dont', $message)
  </code></pre>
  
  <p>but this would probably take a lot more time then in SQL. Is it possible to make the same operation in SQL?</p>