Menu
Community /Pin to ProfileBookmark
@NogDogMar 18.2015 — #If you want the country code and phone number in separate columns, then you can define a unique index across both columns in order to enforce it at the DB level:
Detecting duplicate phone numbers
Hello
I am developing an application where user can enter their phone numbers. The phone numbers can be of any country, may/may not have country code in it. Can start with + or 0 and can be of any length.
The challenge for me to make sure that there are no duplicate phone numbers in the database. I need your help in this. Because if there are 2 same numbers but with different country codes then they should NOT be treated as same.
For example the following two numbers are same but with different country codes:
+919988776655
+4049988776655
Can someone help me?
PS: I m using PHP/MySQL
PPS: For some reason I cannot add a country code dropdown box separately.
Thanks
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogMar 18.2015 — #If you want the country code and phone number in separate columns, then you can define a unique index across both columns in order to enforce it at the DB level:<i>
</i>CREATE UNIQUE INDEX unique_phone_ix ON your_table_name(country_code, phone_number);