Re: Help with REGEXP

2015-03-22 Thread Jan Steinman
> From: Olivier Nicole > > You could look for a tool called "The Regex Coach". While it is mainly > for Windows, it runs very well in vine. I fijd it highly useful to debug > regexps. On the Mac, look for "RegExRx." It lets you paste in text to work on, build a regex, and see the result in real

Re: Help with REGEXP

2015-03-19 Thread Paul Halliday
I don't think it accepts \d, or much of anything else I am used to putting in expressions :) This is what I ended up with and it appears to be working: REGEXP '10.[[:alnum:]]{1,3}.(22[4-9]|23[0-9]).[[:alnum:]]{1,3}' On Thu, Mar 19, 2015 at 11:10 AM, Michael Dykman wrote: > Trying to pattern m

Re: Help with REGEXP

2015-03-19 Thread Michael Dykman
Trying to pattern match ip addresses is a famous anti-pattern; it's one of those things like you feel like it should work, but it won't. Your case, however, is pretty specific. taking advantage of the limited range (I will assume you only wanted 4 sections of IPv4) this should come close: 10[.]\

Re: Help with REGEXP

2015-03-19 Thread Olivier Nicole
Paul, You could look for a tool called "The Regex Coach". While it is mainly for Windows, it runs very well in vine. I fijd it highly useful to debug regexps. Best regards, Olivier -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists