Changing :smilie to ---> :smilie:

[stark427]

Hello there.

When I moved from ezboard to VB me and my members where used to this format of the smilies :

:cry

instead of the default one of VB... which is

: cry : (without the gaps)


So I had changed it... to be like the ezboard one.

I would like to change it back as the :smilies: format is safer - otherwise the way I have it now results to some simple texts to be converted to smilies

So after I change it - I would also like to apply the changes to the old posts, to convert alla the :smilie ones to :smilie:

Anyone who knows which query I should run?

maybe something like this?

UPDATE post SET pagetext=REPLACE(pagetext,':banana',': banana :')

(without the gaps between : and banana.... for every smilie I have...) ?

thanx in advance