Resolved replace string in SQL

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): "\\nas001\disk1\streammedia\------ "

(streammedia is a part of a larger string)

I would like 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.

 

Hi neb, will this help to sort out your needs?
http://www.ntchosting.com/databases/structured-query-language.html
I have no knowledge myself on the subject, so I hope this is what you were seeking. Neil.

 

Looks interesting.
I'll certainly give it a good look.
Thanks Neil.