List:General Discussion« Previous MessageNext Message »
From:Björn Persson Date:November 20 2005 1:01pm
Subject:Re: Mysql Finding the country name from country prefix
View as plain text  
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 database contains only real country codes, no. Then there will be 
at most one match for any number, and if the set of country codes is complete 
there will be exactly one match for any real and complete phone number.

Björn Persson
Thread
Mysql Finding the country name from country prefixabhishek jain19 Nov
  • Re: Mysql Finding the country name from country prefixRhino19 Nov
    • Re: Mysql Finding the country name from country prefixMichael Stassen19 Nov
    • Re: Mysql Finding the country name from country prefixBjörn Persson19 Nov
  • Re: Mysql Finding the country name from country prefixPeter Brawley19 Nov
    • Re: Mysql Finding the country name from country prefixMichael Stassen19 Nov
  • Re: Mysql Finding the country name from country prefixMichael Stassen19 Nov
  • Re: Mysql Finding the country name from country prefixRhino19 Nov
    • Re: Mysql Finding the country name from country prefixMichael Stassen19 Nov
  • Re: Mysql Finding the country name from country prefixRhino19 Nov
    • Re: Mysql Finding the country name from country prefixMichael Stassen20 Nov
      • Re: Mysql Finding the country name from country prefixJasper Bryant-Greene20 Nov
        • Re: Mysql Finding the country name from country prefixMichael Stassen20 Nov
        • Re: Mysql Finding the country name from country prefixBjörn Persson20 Nov