Jasper Bryant-Greene wrote:
> Michael's solution will not produce reliable results as it will return
> at least two results for many different phone numbers, with no way to
> tell which is the correct result.
As long as the database contains Abhishek's bogus "XYZ" and "ZXF" records,
yes. If the d
Jasper Bryant-Greene wrote:
For God's sake, guys, trim your posts!
Sorry.
Michael's solution will not produce reliable results as it will return
at least two results for many different phone numbers, with no way to
tell which is the correct result.
Really? As I said, I don't claim to be a
Michael Stassen wrote:
Anyway, I just wanted to share these observations with the original
poster - and anyone else on the list who is following this issue - to
help put some perspective on the matter. Again, feel free to ignore me
if you like. :-)
All good points. As you say, if the numbers
Rhino wrote:
- Original Message - From: "Michael Stassen"
<[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 3:55 PM
Subject: Re: Mysql Finding the
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 3:55 PM
Subject: Re: Mysql Finding the country name from country
Rhino wrote:
- Original Message - From: "Michael Stassen"
<[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 1:11 PM
Subject: Re: Mysql Finding the
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 1:11 PM
Subject: Re: Mysql Finding the country name from country
Rhino wrote:
> If you parsed the first example, you might assume that I am in
> Brazil, because '55' is the country code for Brazil. (Country codes '5' and
> '555' are not in use at present.)
And they never will as long as "55" is in use, because then phone numbers
would become ambiguous.
Björn
Peter Brawley wrote:
abhishek jain,
>I need to find the country name from the country prefix so eg. i have
>a mysql table with prefix and name as the coumns and with datas like :
>1 USA
>11XYZ
>44UK
>91India
>92Pakistan
>123 ZXF
You mean 'Co
Rhino wrote:
- Original Message - From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:10 AM
Subject: Mysql Finding the country name from country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the c
abhishek jain wrote:
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so eg. i have a
mysql table with prefix and name as the coumns and with datas like :
Prefix, Name
1 USA
11XYZ
44UK
91India
92Pakistan
abhishek jain,
>I need to find the country name from the country prefix so eg. i
have
>a mysql table with prefix and name as the coumns and with datas
like :
>1 USA
>11 XYZ
>44 UK
>91 India
>92 Pakistan
>123 ZXF
You mean 'Country Code', right?
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:10 AM
Subject: Mysql Finding the country name from country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so eg. i have a
mysql table with prefix and name as the coumns and with datas like :
Prefix, Name
1 USA
11XYZ
44UK
91India
92Pakistan
123 ZXF
and i hav
14 matches
Mail list logo
