Skip to content

Instantly share code, notes, and snippets.

@mrl22

mrl22/searchNumber.sql

Created July 2, 2024 14:05
Show Gist options
  • Save mrl22/9e4df3ed1c248c4cf8aca9897b566cb7 to your computer and use it in GitHub Desktop.
Save mrl22/9e4df3ed1c248c4cf8aca9897b566cb7 to your computer and use it in GitHub Desktop.
Download ZIP
3CX CRM MySQL Query for WHMCS Contacts
Raw
searchNumber.sql
select id as contactid, firstname, lastname, email, phonenumber as phonebusiness from tblcontacts where CONCAT('44',TRIM(LEADING '0' FROM TRIM(LEADING '+44.' FROM REPLACE(phonenumber, ' ', '')))) = '@Number';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment