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