Author Topic: Report/Search on Mobile Phone Records with incorrect length (Read 6898 times)

JohnFF · August 16, 2013, 02:34:30 am

Hi guys,

What's the best way to get a list of contact records where the phone number's length is not 11 (as it should be in the UK).

Even better, is there a way of finding a list of contact records where the phone number's length is not 11 or where the first digit is not 0?

Thanks,

JohnFF · August 19, 2013, 01:14:16 am

In case it's of use to others, here is the MySQL command I ended up using.

This is probably only of use for UK numbers, I don't know.

SELECT contact_id, first_name, last_name, phone
FROM civicrm_phone
INNER JOIN civicrm_contact on civicrm_phone.contact_id = civicrm_contact.id
WHERE (((CHAR_LENGTH(phone) != 11)
OR phone LIKE '% %')
OR SUBSTRING(phone, 1, 1)!='0')
AND phone_type_id=2;

CiviCRM Community Forums (archive)

News:

Author Topic: Report/Search on Mobile Phone Records with incorrect length (Read 6898 times)

JohnFF

Report/Search on Mobile Phone Records with incorrect length

JohnFF

Re: Report/Search on Mobile Phone Records with incorrect length