SHARE
TWEET

Untitled

a guest Jun 16th, 2019 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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,}' "
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top