Help: mySQL database, corrupted (sort of)

Discussion in 'MySQL' started by thundercow, Jun 2, 2007.

0
  1. #1
    I paid this guy in india to make me a database of legal glossary terms for my website. He sort of ripped me off but I'll just have to deal with that. He installed a mySQL database of about 2000 entries all of which begin with "defintion of _____" The guy even misspelled "definition" as "defintion". So, I want to just export the DB and then search for "defintion of" and replace it in every record with nothing. THen, I'll have a complete glossary without "defintion of" at the beginning of each term.

    But what software would I use to do the db manipulation? And then when I am done, will I have the same format of db to just plop in through the mysql control panel that comes with cpanel?

    help a brother out.
     
    thundercow, Jun 2, 2007 IP
  2. krt

    krt Well-Known Member

    Messages:
    829
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    120
    #2 
    UPDATE dictionary SET definition = REPLACE(definition, 'defintion of', '');
    Code (markup):
    Use the actual table and field names for your database.
     
    krt, Jun 2, 2007 IP
  3. thundercow

    thundercow Well-Known Member

    Messages:
    246
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    108
    #3
    thanks, that worked fine...it took me a while to figure it out, but I am learning.
     
    thundercow, Jun 2, 2007 IP