[basketmen]

Originally Posted by BirdOPrey5

table prefix, yours in blank so the query would be:

update `post` set pagetext = replace (pagetext, ':lol:' , ':-)')

How big is your posts table (how many posts do you have)? If it's a lot I would suggest turning off the forum just as an extra precaution before running the query.

thank you very much, this is works before for replacing old smilies to new smilies





i have similar problem now


my forum url is changed, from with www ( http://www.domain.com ), to without www ( http://domain.com )




i had try this

update `post` set pagetext = replace (pagetext, 'www.domain.com', 'domain.com')

or
update `post` set pagetext = replace (pagetext, 'http://www.domain.com', 'http://domain.com')




but its not works, its just says Affected Rows: 0 (3.0977s)


please help, how to change it in post table, there are a lot of them in post table