phone numbers query issue

[netfrugal]

I'm not sure how to even start with this one.

I have to query our database for records.
I've been given a list of telephone numbers to start the query.

The first problem I have is the format of the phone numbers.

This is what I've been given:

"6646647776"
"9883337564"
"2738377736"

Our database phone records are not put together that way. We have 3 columns: areacode, phonePrefix, phoneSuffix.

I have no idea how to make this happen.

Any thoughts?

[sfullman]

well, if the db has 3 columns (which is very cool) you can do this

SELECT CONCAT(AreaCode,Prefix,Body) AS PhoneNumber FROM contacts

and so you're comparing two solid number strings.

If the numbers given you have chars in them try doing this first for the comparision:

<?php

$number=preg_replace('/^{1/','',$number);} //lose any possible 1 before everything
$number=preg_replace('/[^{0-9]*/','',$number);} //keep only 0-9

?>
and of course you can then check and make sure you're left with 10 characters before you compare