in mfd9 documentation under SQL -> SQL functions
the \\ don't work in regex101 editor so seem specific to manifold !
? StringRegexpMatches('This text with (XYZ) and more', '.*\\(XY.*', 'i')
=> to test by run View -> NEw command windows -> SQL Ctrl Titde
=> copy the SQL Statement in the command editor
=> the SQL function ll return true in this case
=> the pattern exist but nothing store in groups variable $1 $2 ...
StringRegexpMatches(<string>, <regexp>, <flags>) : <boolean>
Given a string, a regular expression pattern and a flag to use case or to not use case, returns True if the string exactly matches the regular expression and 0 for False otherwise. The <flag> is not optional and must be either 'i' to ignore case or 'c' to use case. This function is used instead of "LIKEX" query operators found in some query engines.
? StringRegexpMatches('Netherlands', 'n.*', 'c')
Returns 0 (meaning False) since the string does not begin with a lower case n character.
? StringRegexpMatches('Netherlands', 'n.*', 'i')
Returns 1 (meaning True) since if case is ignored the upper case N at the first character position matches the regular expression 'n*', that is, text which begins with the letter n or N and then has zero or more of any characters following.
"Because my dad promised me" ( interstellar ) but blackhole don't exist
best hardware with no ads focus on quality features price like manifold see xiaomi