www.webdeveloper.com
Results 1 to 4 of 4

Thread: mysql 5.5 modify 1 column all rows

  1. #1
    Join Date
    Jan 2006
    Location
    Somewhere in the backwoods of Arkansas.
    Posts
    35

    mysql 5.5 modify 1 column all rows

    I'm trying to update all the rows in my database for 1 column through phpmyadmin sql.

    I've tried using the following commands with no luck, and the mysql site hasn't been very useful.

    Code:
    UPDATE 'movies' SET 'Information' = replace(Information, '.vob', ',mpg')
    
    
    UPDATE 'movies' SET 'Information' = REPLACE{'Information', '.vob', '.mpg'};
    
    update [movies] set [Information] = replace([Information],'[.vob]','[.mpg]');

  2. #2
    Join Date
    Sep 2011
    Posts
    59
    try that

    update movies set Information = replace(Information,'.vob','.mpg');

  3. #3
    Join Date
    Jan 2006
    Location
    Somewhere in the backwoods of Arkansas.
    Posts
    35
    Thanks for the fix, that worked perfectly.

  4. #4
    Join Date
    Sep 2012
    Location
    USA
    Posts
    1
    Thanks for this topic and answer , it's help me to solve my problem , I had some problems with database .

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles