Regular Expressions | REGEXP_LIKE(’Michael!’, ’.*’) | +-------------------------------+ | 1 | +-------------------------------+ mysql>  SELECT REGEXP_LIKE(’new*
*line’, ’new\\*.\\*line’); +----------------------------------------------+ | REGEXP_LIKE(’new*
*line’, ’new\\*.\\*line’) | +----------------------------------------------+ | 0 | +----------------------------------------------+ mysql>  SELECT REGEXP_LIKE(’a’, ’^[a-d]’); +----------------------------+ | REGEXP_LIKE(’a’, ’^[a-d]’) | +----------------------------+ | 1 | +----------------------------+ mysql>  SELECT REGEXP_LIKE(’a’, ’A’), REGEXP_LIKE(’a’, BINARY ’A’); +-----------------------+------------------------------+ | REGEXP_LIKE(’a’, ’A’) | REGEXP_LIKE(’a’, BINARY ’A’) | +-----------------------+------------------------------+ | 1 | 0 | +-----------------------+------------------------------+ mysql>  SELECT REGEXP_LIKE(’abc’, ’ABC’); +---------------------------+ | REGEXP_LIKE(’abc’, ’ABC’) | +---------------------------+ | 1 | +---------------------------+ mysql>  SELECT REGEXP_LIKE(’abc’, ’ABC’, ’c’); +--------------------------------+ | REGEXP_LIKE(’abc’, ’ABC’, ’c’) | +--------------------------------+ | 0 | +--------------------------------+ Replaces occurrences in the string  expr  that match the regular expression specified by the pattern  pat with the replacement string  repl , and returns the resulting string. If  expr ,  pat , or  repl  is  NULL , the return value is  NULL . REGEXP_REPLACE()  takes these optional arguments: Prior to MySQL 8.0.17, the result returned by this function used the  UTF-16  character set; in MySQL 8.0.17 and later, the character set and collation of the expression searched for matches is used. (Bug #94203, Bug #29308212) For additional information about how matching occurs, see the description for  REGEXP_LIKE() . • pos : The position in  expr  at which to start the search. If omitted, the default is 1. • occurrence : Which occurrence of a match to replace. If omitted, the default is 0 (which means “replace all occurrences” ). • match_type : A string that specifies how to perform matching. The meaning is as described for REGEXP_LIKE() . mysql>  SELECT REGEXP_REPLACE(’a b c’, ’b’, ’X’); +-----------------------------------+ | REGEXP_REPLACE(’a b c’, ’b’, ’X’) | +-----------------------------------+ | a X c | 2194 • REGEXP_REPLACE( expr ,  pat ,  repl [,  pos [,  occurrence [,  match_type ]]])