How to mass edit database

I hope someone can help me change entries in a database en masse.

In the image, the thumbnail entry is the one that needs changing.

I can only guess this is what you want with the very limited information you gave.

UPDATE Games SET thumbnail = 'http://yourdomain.com/images/wtfareyoutalkingabout.gif' where thumbnail = 'http://yourdomain.com/images/3d.gif';

 RE

 Sorry, didn't try to be vague, just am not sure about how to ask it I guess.

I have been manually updating, removing the "http://yourdomain.com/" leaving the "/images/wtfareyoutalkingabout.gif"

so basically I need to "strip" out the leading website URL.

I would imagine he is needing to update just the URL portion of the thumbnail. Wouldn't something more like this be appropriate. Sorry guess I posted this while you were posting. Now edited.

UPDATE table_name SET field_name = '/images/' WHERE field_name = 'http://jacksonville.dyndns.tv/images/';

Make a backup of the table and run the following command:

UPDATE `Games` SET `thumbnail` = replace(`thumbnail`, 'http://jacksonville.dyndns.tv', '')

 RE

 That is the one!

Thanks Denre and all the others!