title: change the first character in a field
body: <p>I wish to change the first character from a 'U' to an 'S' in a field in my table (MYSQL) , so far I have the following :</p>
  
  <pre><code>UPDATE customers_basket 
  SET products_id = REPLACE(
                     LEFT(products_id,1), 'U', 'S') +      
                     SUBSTRING(products_id, 2, CHAR_LENGTH(products_id)
  );
  </code></pre>
  
  <p>but this does not give me the desired effect, can any one help me?</p>
  
  <p>thank you!</p>