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 :
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.