content_image/803986.jpg
• REGEXP_LIKE( expr , pat [, match_type ]) 

Returns 1 if the string expr  matches the regular expression specified by the pattern pat , 0 otherwise. If expr  or pat  is NULL , the return value is NULL . 

The pattern can be an extended regular expression, the syntax for which is discussed in Regular Expression Syntax. The pattern need not be a literal string. For example, it can be specified as a string expression or table column. 

The optional match_type  argument is a string that may contain any or all the following characters specifying how to perform matching: 

• c : Case-sensitive matching. 

• i : Case-insensitive matching. 

• m : Multiple-line mode. Recognize line terminators within the string. The default behavior is to match line terminators only at the start and end of the string expression. 

• n : The .  character matches line terminators. The default is for .  matching to stop at the end of a line. 

• u : Unix-only line endings. Only the newline character is recognized as a line ending by the . , ^ , and $ match operators. 

If characters specifying contradictory options are specified within match_type , the rightmost one takes precedence. 

By default, regular expression operations use the character set and collation of the expr  and pat arguments when deciding the type of a character and performing the comparison. If the arguments have different character sets or collations, coercibility rules apply as described in Section 10.8.4, “Collation Coercibility in Expressions” . Arguments may be specified with explicit collation indicators to change comparison behavior. 

mysql> SELECT REGEXP_LIKE(’CamelCase’, ’CAMELCASE’); +---------------------------------------+ | REGEXP_LIKE(’CamelCase’, ’CAMELCASE’) | +---------------------------------------+ | 1 | +---------------------------------------+ mysql> SELECT REGEXP_LIKE(’CamelCase’, ’CAMELCASE’ COLLATE utf8mb4_0900_as_cs); +------------------------------------------------------------------+ | REGEXP_LIKE(’CamelCase’, ’CAMELCASE’ COLLATE utf8mb4_0900_as_cs) | +------------------------------------------------------------------+ | 0 | +------------------------------------------------------------------+ 

match_type  may be specified with the c  or i  characters to override the default case sensitivity. Exception: If either argument is a binary string, the arguments are handled in case-sensitive fashion as binary strings, even if match_type  contains the i  character. 

<img src='content_image/803986.jpg'>

mysql> SELECT REGEXP_LIKE(’Michael!’, ’.*’); +-------------------------------+ 

## Note 

MySQL uses C escape syntax in strings (for example, 
  to represent the newline character). If you want your expr  or pat  argument to contain a literal \ , you must double it. (Unless the NO_BACKSLASH_ESCAPES  SQL mode is enabled, in which case no escape character is used.) 

