-1

Is there an easy way of extracting international mobile phones from a database? Has anybody in their midnight surfing come accross open source software or resources that address this?

Any pointers are welcome, thanks!

Updates:

*1: I have a database with phone numbers and wanted to iterate through all phone numbers and only extract or save international mobile (cell) phones. Any open source software or scripts or int. mobile lists for achieving this?

*2: Found a few lists that could be merged to use in script for validating mobile phones.

*3: Google's common Java, C++ and Javascript library for parsing, formatting, storing and validating international phone numbers: http://code.google.com/p/libphonenumber/

Kara
  • 6,115
  • 16
  • 50
  • 57
blueLizzard
  • 31
  • 3

1 Answers1

5

If Suppose you are from India so all the mobile numbers other than +91 country code will be international for you so I have taken Liberty of writing this query for you 

select * from table_name where mobile_number not in (select mobile_number from table_name where mobile_number like '+91%')

This will give you data from your table other than those who are local numbers

Let me know if it was useful for you.

Nagri
  • 3,008
  • 5
  • 34
  • 63
  • Thanks for your reply. I was looking more for an out of the box solution or open source project that goes someway to address international mobile phone recognition/validation, and your answer could be part of the solution. Maybe something like: http://code.google.com/p/libphonenumber/ – blueLizzard Jul 26 '12 at 08:03