Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "SELECT a.Name,a.AdslTel,a.Mobile, b.CodePosty
- FROM on_customers as a, on_customers_detail as b
- WHERE a.Serial=b.CustomerRef and a.TownshipRef='1'
- AND b.CodePosty NOT REGEXP '^[13456789]{5}[1-9]([[:digit:]]){3}([1-
- 9]){1}$' or b.CodePosty REGEXP '([[:digit:]])1{5,}' "
- "SELECT * FROM on_customers WHERE Mobile NOT REGEXP '^(09)
- ([[:digit:]]){9}$'
- or Mobile REGEXP '([[:digit:]])1{5,}' "
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement