International number query belongs to Chinese, the use of SQL statements, there are 189 country code, don't want to use 189 case the when? Is there a better SQL implementation method?

International number
0019110711970867
0061415598156
0085266189626
0085266328726
0019110709473740
0085263158308
0066648019076


String beginning country code

Malaysia 0060
Indonesia 0062
Jordan 00962
The Philippines 0063
Singapore 0065
Iraq's 00964
Thailand 0066
Brunei 00673
Saudi Arabia 00966
Japan's 0081
South Korea 0082
Israel 00972
Vietnam 0084
North Korea's 00850
Qatar 00974
Hong Kong 00852
Macau 00853
Mongolia 00976

CodePudding user response:

Directly associated with country code table is not good