Anyone can solve mysql ?

Discussion in 'Programming' started by lilianchen, Sep 12, 2008.

  1. #1
    Please solve my mysql problem

    I have field on mysql

    ID | Title
    ------------
    1 | Xxxx Yyyyy
    2 | Www ZZZ

    I need to change to

    ID | Title
    ------------
    1 | xxxx_yyyy
    2 | www_zzzz

    How to do it ?
     
    lilianchen, Sep 12, 2008 IP
  2. serialCoder

    serialCoder Guest

    Best Answers:
    0
    #2
    try this sql query

    UPDATE your_table set Title = LOWER(Title)
     
    serialCoder, Sep 12, 2008 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    Try this
    UPDATE your_table set Title = REPLACE(LOWER(Title), ' ', '_')
    Code (markup):
     
    mwasif, Sep 12, 2008 IP
  4. Mr Business

    Mr Business Peon

    Messages:
    58
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    do u have msn or skype so i can guide you through the process?
     
    Mr Business, Sep 12, 2008 IP