title: MySQL Change a column ENUM value
body: <p>I have a MySQL table "<code>content</code>" which has a column <code>page_type</code> of type <code>ENUM</code>. The <code>ENUM</code> values are <code>NEWS</code> &amp; <code>PRESS_RELEASE</code>.  I need to replace <code>NEWS</code> with <code>FEATURED_COVERAGE</code>:</p>
  
  <pre><code>ALTER TABLE `content` CHANGE `pagetype` `pagetype` ENUM('FEATURED_COVERAGE','PRESS_RELEASE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
  </code></pre>
  
  <p>But now the records in the table, which earlier had page_type <code>NEWS</code> are now empty, and there is no way that I can identify which records are <code>NEWS</code>, so that I can rename those to <code>FEATURED_COVERAGE</code>.</p>
  
  <p>How to resolve such issues?</p>