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