Windows 7: SQL string manipulation

I am rather a novice (or maybe illiterate) in SQL statements and have the following problem:



SQL database: video.db
table: MGOFile
column: File
data entries in that column (>100): "streammedia"

(stringmedia is a part of a larger string)

I would lite to change in all occurences of "streammedia" with the string "Media".

Can anyone help me write the correct SQL statement so that I can execute this SQL statement?

thank you ver much in advance.