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;