MySQL Help: How to change the case of the text in the whole database?

Discussion in 'MySQL' started by kslokesh, Mar 28, 2009.

0
  1. #1
    MySQL Help needed..

    1) Is there any method by which I can change/convert the case of the text in the existing database records into UPPERCASE ?

    2) Any method to convert and save the data entered in future irrespective of the case it is being entered into UPPERCASE..

    Please help me in this regard..
     
    kslokesh, Mar 28, 2009 IP
  2. Siteapps

    Siteapps Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    UPDATE table SET field = UPPER(field);
     
    Siteapps, Mar 28, 2009 IP