Re: Daten in kommasepariertem Feld mit REPLACE richtig ersetzen

[Peter Brawley]

SQL is by design an incomplete language. For example the atomicity rule is fundamental. SQL is simply not designed to manipulate multi-valued data cells.

As I said, a complete language like PHP can easily massage a comma-separated list by turning it into an array, transform values as desired, then turn it back into a comma-separated string.

Something like the PHP can be done much more awkwardly in a MySQL stored procedure ... you would hand the string to a While loop, parse it comma by comma, transform the values as required, and thus prepare a replacement string. "Automatic"? No. But doable.

Meanwhile send a bottle of stale beer to the eejit who designed this aspect of your db.