Mysql Update

[NetworkTown.Net]

Hi

Dose any one know of a script that can do the following:

When i type in a form .flv and submit the form will update all .wmv in my database to .flv is it possible?

 

[Noobie]

The sql is:
UPDATE {TABLE_NAME} SET {FIELD_NAME} = REPLACE ({FIELD_NAME}, '.wmv', '.flv' )

 

[NetworkTown.Net]

Ok so if my DB name is arcade and the table is games it will look like this:

UPDATE {user_arcade} SET {games} = REPLACE ({games}, '.wmv', '.flv' )

Is that correct?

 

[Noobie]

minus the braces.

UPDATE user_arcade SET games = REPLACE (games, '.wmv', '.flv' )

 

[NetworkTown.Net]

Thanks i will test it in abit.