Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: SQL string manipulation

04 Oct 2011   #1

Windows 7 Ultimate 32-bit
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.

My System SpecsSystem Spec


 SQL string manipulation

Thread Tools

Similar help and support threads for2: SQL string manipulation
Thread Forum
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

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:00 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33