MySQL's regex library doesn't have all those Perl features. You can use
the pcre-compatible extension from http://www.xcdsql.org/MySQL/UDF/, or
just use two clauses in the WHERE: one should be
col NOT RLIKE "linux$"
Baron
Tang, Jasmine wrote:
Hi,
I need to match anything that start with "
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