How to make an global update with php/mysql to add a value to all entries??

[iBuddy]

Alright guys here is my problem.

I have a mysql database with over 80+ entries, I need a global way of updating all my entries in mysql. for example I have a column called "filename" and right now the filenames are "blahblah" or "example1" but I need to have the file extension on there, and its always going to be ".flv" so is there a sql I can run to basically add ".flv" to every entry in the "filename" column?

thanks

[suomynonA]

UPDATE table_name SET filename=concat(filename,".flv");

But please, don't double post in different subforums.