MySQL 정규표현식 함수
MySQL5.7 에서는 아래와 같은 함수를 지원한다.
NOT REGEXP : Negation of REGEXP
REGEXP : Whether string matches regular expression
RLIKE : Whether string matches regular expressio
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
MySQL :: MySQL 5.7 Reference Manual :: 12.7.2 Regular Expressions
12.7.2 Regular Expressions Table 12.13 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular expression RLIKE Whether string matches regular expression A regular expression is a powe
dev.mysql.com
MySQL 8.0에서는 아래와 같은 함수를 지원한다.
NOT REGEXP : Negation of REGEXP
REGEXP : Whether string matches regular expression
REGEXP_INSTR() : Starting index of substring matching regular expression
REGEXP_LIKE : Whether string matches regular expression
REGEXP_REPLACE() : Replace substrings matching regular expression
REGEXP_SUBSTR() : Return substring matching regular expression
RLIKE : Whether string matches regular expression