Need SQL command for this
Please could you help me with this. In my database for an entertainment site, I have several dozen fields containing the URL of where the clips are located. As it would be too laborious to manually change each and every one of these I wish to change the url from video/ to http://server2.site.com. I know there is a command to do this with something like "select * from" however it's been so long since I've used MySQL commands that I've forgotten most of them. Please could someone tell me how to replace this value?
Appreciate it loads, thanks guys <3.
