title: MySQL Search and replace entire fields not part of it
body: <p>I want to replace an entire MySQL field in a wordpress database. I want to replace 'Mark' with 'Tom' in custom field 'employee'</p>
  
  <p>i have the following working query:</p>
  
  <pre><code>UPDATE 'wp_postmeta' 
  SET 'meta_value' = replace(meta_value, 'Mark', 'Tom') 
  WHERE 'meta_key' LIKE 'employee'
  </code></pre>
  
  <p>The problem i am having is that i dont want to replace 'Mark' in 'Mark Frey' (->Tom Frey) or 'Markus' (->Tomus).
  I only want to replace the entire field, and not part of it. The results should look like:</p>
  
  <p>Mark -> Tom</p>
  
  <p>Mark Frey -> Mark Frey</p>
  
  <p>Markus -> Markus</p>
  
  <p>Is it possible to do this in phpmyadmin?</p>