|04 Oct 2011||#1|
| || |
SQL string manipulation
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.
|My System Specs|
|Similar help and support threads for2: SQL string manipulation|
|Image manipulation||Music, Pictures & Video|
|Invalid Class String||BSOD Help and Support|
|Excel 2007: a question about date and time manipulation||Software|
|Manipulation of items pinned to Start Menu||Customization|
|Windows manipulation||Chillout Room|
|String value changes not showing???||Customization|