How to Update First Character of Each Row to Uppercase in MySQL

smallwei 9:22 pm on November 13, 2009 | Answers: 1    
Tags: character (8), mysql (35), row (4), uppercase, use (24)

Rate Knowledge:

 Loading ...

• smallwei 9:22 pm on November 13, 2009
  

  -- Replace table_name and field_name
  UPDATE table_name 
  SET field_name = CONCAT(UPPER(SUBSTRING(field_name,1,1)),LOWER(SUBSTRING(field_name,2)));