If I have a MySQL table with dialing codes and a corresponding description (see below) and I want to lookup the best match for a phone number.. What would the SQL look like to do it? or would it take more than just SQL to get to the best result?
Thanks..
Later..
Example numbers, (random end digits so I don't know who's they are.)
00442085673456 - UK London 00441273786524 - UK Geographic 00441444456789 - UK Geographic 00447796345678 - Vodafone Mobile 00447930987321 - O2 Mobile 0027117654321 - South Africa 0016047863252 - USA/Canada ______________________ Code | Data ----------------------------------- 001 USA/Canada 0027 South Africa 0031 Netherlands 0032 Belguim 0033 France 0034 Spain 0039 Italy 0041 Switzerland 0043 Austria 0045 Denmark 0046 Sweden 0047 Norway 0049 Germany 00441 UK geographic 00442 UK geographic 0044207 UK London 0044208 UK London 0044370 Vodafone 0044378 Vodafone 0044390 Vodafone 0044401 O2 0044402 O2 0044403 O2 0044408 O2 0044410 O2 0044411 O2 0044421 Vodafone 0044467 Vodafone 0044468 Vodafone 0044585 O2 0044589 O2 0044770 O2 0044771 O2 0044775 O2 0044779 Vodafone 0044783 Vodafone 0044793 T-Mobile 0044794 T-Mobile 0044795 T-Mobile 0044797 Orange 0044799 Vodafone 0044080 Free call 0044802 O2 0044831 Vodafone 0044836 Vodafone 0044845 Local Rate 0044850 O2 0044860 O2 0044870 National rate 0044966 Orange 0044973 Orange 0044976 Orange 0044990 UK geographic
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
