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 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!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
