MySQL Help updating TV content in the DB

Support
1

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

2

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, ',', ' ')

3

HalftrainedHarry,

Thanks so much

Roy