Search and replace in posts
 

I'm a real noob with Mysql commands, and since I know php and mysql use dots and komma's etc. I'm afraid to just try things.

I've got an image which in the forum is called by
:duim:

I want to change the image so it's called by:
(Y)

Changing the image and the shortcut is no problem, but I would like the mysql command to change the already used :duim: in posts to (Y) so also the older post get the new shortcut.

I don't know if this is possible because there are : en () signs which php and mysql also uses if I'm correct, so I really need a good Mysql command to do this this, from somebody who knows what he's doing. If possible from staff.