Database Reference
In-Depth Information
SELECT '123a567' ˜ '2*a'
/* returns True */
SELECT '123a567' ˜ '7*a'
/* returns True */
SELECT '123a567' ˜ '37*'
/* returns True */
SELECT '123a567' ˜ '87*'
/* returns False */
/* matches preceding character one or more times */
SELECT '123a567' ˜ '2+'
/* returns True */
SELECT '123a567' ˜ '2+a'
/* returns False */
SELECT '123a567' ˜ '7+a'
/* returns False */
SELECT '123a567' ˜ '37+'
/* returns False */
SELECT '123a567' ˜ '87+'
/* returns False */
/* makes the preceding character optional */
SELECT '123a567' ˜ '2?'
/* returns True */
SELECT '123a567' ˜ '2?a'
/* returns True */
SELECT '123a567' ˜ '7?a'
/* returns True */
SELECT '123a567' ˜ '37?'
/* returns True */
SELECT '123a567' ˜ '87?'
/* returns False */
/* Matches the preceding item exactly {n} times */
SELECT '123a567' ˜ '5{0}'
/* returns True */
SELECT '123a567' ˜ '5{1}'
/* returns True */
SELECT '123a567' ˜ '5{2}'
/* returns False */
SELECT '1235567' ˜ '5{2}'
/* returns True */
SELECT '123a567' ˜ '8{0}'
/* returns True */
SELECT '123a567' ˜ '8{1}'
/* returns False */
/* Matches the contents exactly */
SELECT '123a567' ˜ '(23a5)'
/* returns True */
SELECT '123a567' ˜ '(13a5)'
/* returns False */
SELECT '123a567' ˜ '(23a5)7*'
/* returns True */
SELECT '123a567' ˜ '(23a5)7+'
/* returns False */
/* Matches any of the contents */
SELECT '123a567' ˜ '[23a8]'
/* returns True */
SELECT '123a567' ˜ '[8a32]'
/* returns True */
SELECT '123a567' ˜ '[(13a5)]'
/* returns True */
SELECT '123a567' ˜ '[xyz9]'
/* returns False */
SELECT '123a567' ˜ '[a-z]'
/* returns True */
SELECT '123a567' ˜ '[b-z]'
/* returns False */
/* Matches a nonalphanumeric */
SELECT '$50K+' ˜ '\\$'
/* returns True */
SELECT '$50K+' ˜ '\\+'
/* returns True */
SELECT '$50K+' ˜ '\\$\\+'
/* returns False */