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