Attempts to utilize a regular expression to retrieve data from a MySQL table often encounter the error "repetition-operator operand invalid." This article delves into the cause of this error and provides a solution.
Unlike Perl Compatible Regular Expressions (PCRE), MySQL uses Henry Spencer's POSIX 1003.2-compliant implementation. Therefore, it does not support the question mark (?) modifier, which denotes non-greedy (lazy) quantifiers like *? and ?.
To resolve this issue, replace the non-greedy quantifier with its greedy counterpart. Additionally, consider using a negated character class to prevent matches on elements like some style/" src="a.png"> and
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
