title: CONCAT but if already done, ignore
body: <p>I would like to add an asterisk (*) after a person's name if a piece of information about the profile is outdated.</p>
  
  <p>Donald</p>
  
  <pre><code>$stmt = $conn-&gt;prepare("UPDATE contacts SET name = concat(name, '*') WHERE phone = ?");
  $stmt-&gt;bind_param("s",$phone);
  $stmt-&gt;execute();
  </code></pre>
  
  <p>Donald*</p>
  
  <p>This works fine the first time but if nothing has changed and I update the profile, it adds another asterisk so then the name is
  Donald**. Next time it is Donald*** etc.</p>
  
  <p>What would be the solution to check if the name already has an asterisk and if so, do nothing?</p>