469,951 Members | 2,721 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 developers. It's quick & easy.

Need update query--Remove the coma ","

268 100+
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
Aug 10 '06 #1
1 1487
ronverdonk
4,258 Expert 4TB
Why are you posting the same query in 2 forums???
Read the reply to the PHP forum!

Ronald :cool:
Aug 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Johann Blake | last post: by
1 post views Thread by manchin2 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.