Regular Expressions • REGEXP_LIKE( expr ,  pat [,  match_type ]) • 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. 2193 mysql>  SELECT REGEXP_LIKE(’Michael!’, ’.*’); +-------------------------------+ 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.) 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. 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. If characters specifying contradictory options are specified within  match_type , the rightmost one takes precedence. The optional  match_type  argument is a string that may contain any or all the following characters specifying how to perform matching: 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. 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 . 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 | +------------------------------------------------------------------+ Note