title: Renaming Filenames In Table
body: <p>I have a table as </p>
  
  <pre><code>'310', 'D', '1', '0', 'Clowns.jpg', ?, '63527560196'
  '311', 'D', '1', '1', 'Clowns_102_x_102.jpg', ?, '63527560197'
  '312', 'D', '1', '1', 'Clowns_45_x_45.jpg', ?, '63527560197'
  '313', 'D', '1', '1', 'Clowns_80_x_80.jpg', ?, '63527560197'
  '314', 'D', '1', '1', 'Clowns_120_x_120.jpg', ?, '63527560198'
  '315', 'D', '1', '1', 'Clowns_180_x_180.jpg', ?, '63527560198'
  '316', 'D', '1', '1', 'Clowns_300_x_300.jpg', ?, '63527560198'
  </code></pre>
  
  <p>I want to rename the files called Clowns to Clowning so the data would look like this</p>
  
  <pre><code>'310', 'D', '1', '0', 'Clowning.jpg', ?, '63527560196'
  '311', 'D', '1', '1', 'Clowning_102_x_102.jpg', ?, '63527560197'
  '312', 'D', '1', '1', 'Clowning_45_x_45.jpg', ?, '63527560197'
  '313', 'D', '1', '1', 'Clowning_80_x_80.jpg', ?, '63527560197'
  '314', 'D', '1', '1', 'Clowning_120_x_120.jpg', ?, '63527560198'
  '315', 'D', '1', '1', 'Clowning_180_x_180.jpg', ?, '63527560198'
  '316', 'D', '1', '1', 'Clowning_300_x_300.jpg', ?, '63527560198'
  </code></pre>
  
  <p>So I tried this</p>
  
  <pre><code>UPDATE new_images 
  SET 
  filespec = 'clowns100' + MID(filespec, 7, LENGTH(filespec) - 6);
  </code></pre>
  
  <p>However I got </p>
  
  <blockquote>
    <p>Error Code: 1292. Truncated incorrect DOUBLE value: 'clowns100'</p>
  </blockquote>