I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!)
Now I am trying to create a query that can add these spaces in automatically so I don’t end up spending weeks manually adding spaces to all the data in every record.
The field is called meta_keyword, and the data looks something like this:
...but I need it to look like this:
[123abc, 456def, 789ghi, ]
Anyone got any suggestions on how spaces can be added after each comma automatically using an update query?..