Little help with 'sql replace'

[thesha]

I am trying to replace ',' (comma) with ', ' (comma and one space) in all posts.

How to run a sql query? Say table name is 'table1'. Column name is 'column1'.

thanks.

--------------- Added 1207973435 at 1207973435 ---------------

OK. I found out this query on the internet. Worked good.

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

http://www.nikmakris.com/2005/mar/29.html

thanks!