I need to match anything that start with "foo" then followed by a string
containing letter/number/underscore/dot but NOT end with the string
"linux". When I use the pattern 'foo[(a-z|0-9|_|.)]+(?!linux)' , I got
"ERROR 1139 (42000): Got error 'repetition-operator operand invalid'
from regexp". I got the look-ahead assertion syntax (?!string) from
Perl regexp, but mysql apparently doesn't like that.
Specially, the following should match:
but this should NOT match