List:General Discussion« Previous MessageNext Message »
From:Jasmine Tang Date:September 24 2007 9:22pm
Subject:regexp negate string help
View as plain text  
Hi,
 
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:
 
foodafdlj_endwithx
food3242jljlsd.endwithn
 
but this should NOT match
 
foosdfjl.blah_linux 
 
any suggestions?
 
thanks!
 

Thread
regexp negate string helpJasmine Tang24 Sep
  • Re: regexp negate string helpBaron Schwartz26 Sep