#1139 – Got error ‘repetition-operator operand invalid’ from regexp

by

According to the MySQL manual

MySQL uses Henry Spencer’s implementation of regular expressions, which is aimed at conformance with POSIX 1003.2

POSIX regexes don’t support using the question mark ? as a non-greedy (lazy) modifier to the star and plus quantifiers like PCRE (Perl Compatible Regular Expressions). This means you can’t use +? and *?

It looks like you’ll just have to use the greedy version, which should still work. To avoid the matching of things like <img style="/*some style*/" src="https://stackoverflow.com/questions/18317183/a.png"> <script src="www.example.com/js/abc.js">, you can use a negated character class:

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

Note: The " doesn’t have to escaped and the .* at the beginning is implied.

More Related Contents:

  1. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  2. What is better subquery vs literal on IN clause in mysql
  3. How can I select data from different tables?
  4. SQL query return data from multiple tables
  5. Select all columns except one in MySQL?
  6. MySQL SELECT only not null values
  7. What is MySQL row order for “SELECT * FROM table_name;”?
  8. Select mysql query between date?
  9. How to count words in MySQL / regular expression replacer?
  10. mysql select from n last rows
  11. MySQL select with CONCAT condition
  12. Checking multiple columns for one value
  13. Sort by order of values in a select statement “in” clause in mysql
  14. MySQL – How to select data by string length
  15. Mysql select distinct
  16. Return a default value if single row is not found
  17. How to select one row randomly taking into account a weight?
  18. MySQL – Select the last inserted row easiest way
  19. Sum results of a few queries and then find top 5 in SQL
  20. Syntax error when using except in a query
  21. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  22. SQL query to check if a name begins and ends with a vowel
  23. Using index, using temporary, using filesort – how to fix this?
  24. MySQL : retrieve a large select by chunks
  25. MySQL – insert data from another table merged with constants
  26. Insert data into table with result from another select query
  27. How to SELECT by MAX(date)?
  28. MySQL matching unicode characters with ascii version
  29. remove all numeric characters from column mysql
  30. mySQL regex in the where clause

Leave a Comment