I am rather a novice (or maybe illiterate) in SQL statements and have the following problem:
SQL database: video.db
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.