MySQL TRIM spaces inside text

Question

I have a DB with users table. One of the fields is cellphone, but is as VARCHAR type. Some users modify their phone with correct and desired behavior, a number without spaces. But other users just add it and let spaces between chars.

Desired data:
5354663598

Some cases:
53 5 466 3598

In PHP I can solve this with a foreach, and later a str_replace(" ", "", $user->cellphone);

But I just want to know if there is a MySQL function for it.

Thanks!

chris85 · Accepted Answer · 2017-10-18 21:43:05Z

4

You can use REPLACE:

REPLACE(str, find_string, replace_with)

edited Oct 18, 2017 at 21:43

chris85

23.9k7 gold badges37 silver badges51 bronze badges

answered Oct 18, 2017 at 21:41

Ferenc Kurucz

1424 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Erich García Over a year ago

Complete query please! something like UPDATE users REPLACE(phone," ","")

Erich García · Accepted Answer · 2017-10-19 00:09:46Z

0

Uhmm, solved!, thanks Ferenc Kurucz.

UPDATE users SET phone = REPLACE(phone," ","")

answered Oct 19, 2017 at 0:09

Erich García

1,91423 silver badges33 bronze badges

Collectives™ on Stack Overflow

MySQL TRIM spaces inside text

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related