Need update query--Remove the coma ","

[vssp]

Hi friends

Thanks for your repaly for all my question..
I need one update query. I have selected the datas are insert with coma ",".

Query
SELECT city
FROM `locations`
WHERE city REGEXP ','

I got the result..
Silver Spring,
Elkins,
PORTLAND,
Baltimore,

I need like this
Silver Spring
Elkins
PORTLAND
Baltimore

I need to remove the "," and restore the values .

[ronverdonk]

How about this one?

SELECT replace(city, ",", "")
FROM `locations` 
WHERE city REGEXP ','

Ronald :cool: