Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Converting Phone Number

Posted on 2014-04-14
2
Medium Priority
?
309 Views
Last Modified: 2014-04-14
The phone numbers in my DB have this format:
(307)266-3290

I would like to convert them all to this format:
307-266-3290

I think I have to use SELECT CONCAT but not sure how to write the query or optionally just change the output in php.
0
Comment
Question by:seopti
2 Comments
 
LVL 25

Accepted Solution

by:
SStory earned 2000 total points
ID: 39999175
select concat(concat(substr(PhoneNo,2,3),"-"),substr(PhoneNo,6)) as NewPhoneNo

Replace PhoneNo with the valid field in two places in the above> Of course if you want to change it, it will be an update. I'd run the select first and get that right before updating.
When ready,
Update yourtable
set PhoneNo=concat(concat(substr(PhoneNo,2,3),"-"),substr(PhoneNo,6))

or whatever works in the select
0
 
LVL 31

Expert Comment

by:Marco Gasi
ID: 39999188
Using php:

$number = "(307)266-3290";
$token = array("(", ")");
$replacement = array("", "-");
$number = str_replace($token, $replacement, $number);
echo $number;

Open in new window

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question