Regex issue in SQL query

Question

I cant seem to get the following search query to work in phpMyadmin.

 SELECT * FROM `my_table` WHERE `content` REGEXP 'https?\:\/\/(.*?(?<!cgi\.)ebay)';

Here is the error that I get:

 #1139 - Got error 'repetition-operator operand invalid' from regexp 

The regular expression itself works perfectly fine when I created it so not sure what is the problem, see here: http://regex101.com/r/qN2jX4/1

Answer 1

The .*? looks suspect as does the ?<. Removing the extra ? fixes the error:

WHERE `content` REGEXP 'https?\:\/\/(.*(<!cgi\.)ebay)';

Perhaps this does what you want.