|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Mysql Finding the country name from country prefix
From: abhishek jain (mail
ejain.com)
Date: Sat Nov 19 2005 - 07:10:53 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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**
*
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]