regexp_like(string, pattern [,start])

Return true if a string matches a regular expression, otherwise return false. Note that regexp_like does not require the entire string to match, only that some portion of the string matches the regular expression. To check if the entire string matches a pattern, the ^ and $ characters must be used to match the start and end of the string.

Examples

if regexp_like("foo,12345,bar", "[0-9]+") then ... end
if regexp_like("9872398479", "^[0-9]+$") then ... end