-2

I want to remove ,0 and | and , at once from the same value which is here A300,0|A232,0|A232,

test table

+----+------+---------------------+
| id   | name                  |
+----+------+---------------------+
|  1   | A300,0|A232,0|A232,   |
+----+------+---------------------+

SELECT REPLACE(REPLACE(t.name, '|', ' '), ',0', '' , ',' , '') AS myresult
from test as t;

0 Answers0