REGEXP_LIKE

Syntax

REGEXP_COUNT(str, pattern [, match_param])

Overview

REGEXP_LIKE compares str with the pattern given as a regular expression.

It follows the POSIX regular expression standard.

Parameter

Parameter	Description
str	Arbitrary operation that returns a string. It can be of type TEXT or CHAR.
pattern	Arbitrary operation that returns a string written as a regular expression. Arbitrary operation that returns a string. It can be of type TEXT or CHAR.
match_param	Arbitrary operation returning a string. It sets how to check for patterns. The following values can be used, and multiple values can be used simultaneously. i : It is not case sensitive. c : It is case sensitive. n : Periods (.) include line breaks. m : The input string is more than one line. x : This ignores whitespace characters in the pattern.

Example

SELECT REGEXP_LIKE('Hello World', 'world', 'i');
 regexp_like 
-------------
 t
(1 row)