Results 1 to 3 of 3

Thread: Changing data

  1. #1
    Join Date
    Jul 2009
    Posts
    23

    Unanswered: Changing data

    Hello
    I hope you guys will understand what i mean ,

    i have a database and in this table i have a column named "source"

    now, i have lots of data there in the shape of text, names of the sources.

    now i have a specific source name i want to change(and there are lots of them)
    lets say i want to change it from "X" to "Y"

    is there any way to changed it automatically ? not one by one

    thanks alot

    Danny

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    update mytable set mycolumn="blah-di-blah" where mycolumn="oujamaflip"
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2009
    Posts
    23

    Thanks

    yeap...

    just did it more specific

    UPDATE table SET author_name='Aju Menu' WHERE author_name='Natal Menu';


    Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •