Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. CREATE PROCEDURE bankCustomers()
  2. select id, if(
  3. customer_name regexp binary "^[A-Z][a-z]* [A-Z][a-z]*$" and
  4. card regexp "^1234-[0-9]{4}-[0-9]{4}-[0-9]{4}$" and
  5. issue_date regexp "^(0[1-9]|[12][0-9]|3[01])-(0[1-9]|1[012])-(200[0-9]|201[0-6])$",
  6. 'true', 'false') as result
  7. from records;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement