Sql

Search

mysql regex phone number

-- works on international numbers

SELECT id, cust_num FROM `leads` WHERE cust_num REGEXP '+(9[976]d|8[987530]d|6[987]d|5[90]d|42d|3[875]d|
2[98654321]d|9[8543210]|8[6421]|6[6543210]|5[87654321]|
4[987654310]|3[9643210]|2[70]|7|1)d{1,14}$'

Comment

PREVIOUS	NEXT

Code Example
Sql :: sqlcmd no headers
Sql :: mysqli_free_result
Sql :: reset counter postgres
Sql :: psql command not found windows
Sql :: in in sql
Sql :: oracle for loop on list
Sql :: How to take sum of column with same id and different table in SQL?
Sql :: List all the items that have not been part of any purchase order. sql
Sql :: mssql default connection string
Sql :: mysql dependency for spring boot
Sql :: triggers in mysql example
Sql :: Failed to process SQL command - ORA-28014: cannot drop administrative user or role
Sql :: make selected text uppercase mssql
Sql :: sql update by id
Sql :: postrgesql concat 2 columns divided by ;
Sql :: add column first position mysql
Sql :: mysql calcular idade
Sql :: sql query print strings and int
Sql :: sql searching via key word
Sql :: select top values sql
Sql :: create and attach user to a postgresql database
Sql :: mysql show create db
Sql :: wp_query raw sql
Sql :: was not locked with LOCK TABLES
Sql :: sql select without column name
Sql :: sql not
Sql :: aggregate functions
Sql :: postgres where
Sql :: oracle insert multiple rows into same table
Sql :: join multiple tables in sql same table

Search

SQL

mysql regex phone number

ADD CONTENT