List:General Discussion« Previous MessageNext Message »
From:abhishek jain Date:November 19 2005 1:10pm
Subject:Mysql Finding the country name from country prefix
View as plain text  
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
11        XYZ
44        UK
91        India
92        Pakistan
123      ZXF
and i have a number like 911122334455 and i need t match that to india.
I cannt do that directly by this statement select name from 
country_table where prefix='91'; for the simple reason as i do not have 
the length or the no. of digits the prefix is beforehand.
Pl. help me out.
Quick help will be appreciated.
-- 
--
Regards
*Jain**
*

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