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.
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.
I think this might work:
UPDATE modx_site_tempvar_contentvalues SET value = REPLACE(value, ' ', ',') WHERE tmplvarid=44;
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