mysql php question... changing to proper case? how to

Discussion in 'MySQL' started by cgo85, Apr 7, 2008.

0
  1. #1
    I have 2 fields in a table that all the letters are upper case. I want to change these to proper case (ex. KING COUNTY -> King County). The fields are named city, and county.

    Your help is appreciated.
     
    cgo85, Apr 7, 2008 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    You have two field names or the data in those fileds? Which do you want to change?
    edit: read that again and it looks like data.

    Data is easy just use phpmyadmin and edit the data. Find the record and select edit.

    Field names may require some modifications to the script that pulls the data.
     
    Colbyt, Apr 7, 2008 IP
  3. cgo85

    cgo85 Peon

    Messages:
    380
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I want to alter the data that's within the fields. There are thousands of records so I can't go in manually and do each one. I'm looking for a query that that I can run that will auto edit all of them.
     
    cgo85, Apr 7, 2008 IP
  4. Petey

    Petey Peon

    Messages:
    68
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Petey, Apr 7, 2008 IP