Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. "SELECT a.Name,a.AdslTel,a.Mobile, b.CodePosty
  2. FROM on_customers as a, on_customers_detail as b
  3. WHERE a.Serial=b.CustomerRef and a.TownshipRef='1'
  4. AND b.CodePosty NOT REGEXP '^[13456789]{5}[1-9]([[:digit:]]){3}([1-
  5. 9]){1}$' or b.CodePosty REGEXP '([[:digit:]])1{5,}' "
  6.  
  7. "SELECT * FROM on_customers WHERE Mobile NOT REGEXP '^(09)
  8. ([[:digit:]]){9}$'
  9. or Mobile REGEXP '([[:digit:]])1{5,}' "
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement