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 .
Thanks
Vssp

[ronverdonk]

Why are you posting the same query in 2 forums???
Read the reply to the PHP forum!

Ronald :cool: