MySQL Help updating TV content in the DB

Summary

Content was entered incorrectly into a Tag TV. The content editor added Commas in the tags. So I want MySQL to update the content in the table.

Helpful DB info

I want to update the table modx_site_tempvar_contentvalues
I want to limit the change to records with the tmplvarid 44. (id of the TV)
I want to replace the ‘,’ with a space.

IE Change Degler,Roy with Degler Roy.

I can use an output modifier when I display the content to add in the comma.

Solution???

I think this might work:

UPDATE modx_site_tempvar_contentvalues 
SET 
	value = REPLACE(value,
		' ',
		',')
WHERE
	tmplvarid=44;

Environment

MODX 2.8.4. on MODXCloud
I will use Sequel Pro to run the MySQL.

There are over 1500 records with incorrect data forcing the use of MySQL instead of manual editing

Thanks

Roy

The correct name of the table is modx_site_tmplvar_contentvalues.

Also, I believe you have to swap the parameters of the REPLACE function:
The syntax is REPLACE(field_name, string_to_find, string_to_replace) or in your case REPLACE(value, ',', ' ')

HalftrainedHarry,

Thanks so much

Roy