Why Does MySQL\'s Regular Expression Throw \'Repetition-Operator Operand Invalid\' and How Can I Fix It?

<h2>#1139 - Error 'Repetition-Operator Operand Invalid' in MySQL Regular Expression</h2>

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.

<h3>Cause of the Error</h3>

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 ?.

<h3>Solution</h3>

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 <img>some style/" src="a.png"> and <script src="www.example.com/js/abc.js">.

%<img[^>]*src="http://www'

Note that the " character is not escaped, and the .* at the start is implied.

The above is the detailed content of Why Does MySQL\'s Regular Expression Throw \'Repetition-Operator Operand Invalid\' and How Can I Fix It?. For more information, please follow other related articles on the PHP Chinese website!