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]');

---

try that

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

Thanks for the fix, that worked perfectly.

Thanks for this topic and answer , it's help me to solve my problem , I had some problems with database .