Updating a Part of string in MySQL

I want to know if it is possible to update a small part of string in MySQL. For example, you have 100 pages stored in MySQL table. In each page there is a 开发者_JAVA技巧link which labeled at "2010 Updates". You want to change the Label to "2011 Updates". Can we do that using MySQL Update statement???

Thank you so much

You could try this video http://www.sebastiansulinski.co.uk/tutorials/play/261
I would just do a select statement, and looping through it, running a regex on each row, then updating said row; but the video gives you another option.