Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM addresses WHERE streetnumber '^11[^[:digit:]]*$'
- SELECT * FROM addresses WHERE streetnumber ~ '^:streetNumber[^[:digit:]]*$'
- SELECT * FROM addresses WHERE streetnumber ~ ('^' || :streetNumber || '[^[:digit:]]*$')
Add Comment
Please, Sign In to add comment