title: mysql - update table use regexp
body: <pre><code>SELECT id FROM people WHERE id REGEXP 'id-(\d)*';
  </code></pre>
  
  <p>result </p>
  
  <pre><code>id-1
  id-2
  id-3
  </code></pre>
  
  <p>This above query works but when i run update query below, it don't affect any rows</p>
  
  <pre><code>UPDATE people SET id = REPLACE(id, 'id-(\d)*', 'id-4');
  0 row(s) affected
  </code></pre>
  
  <p>Somebody can explain for me, what wrong ?</p>