REGEXP HELP!!

Anon

Here's the example I need a REG EXP to find;

I have a set of strings that include "G9" and "G9,5"

I want to find only the "G9" ones and not the "G9,5"

How do I do this??
Everything I've tried either finds both or neither.

Please help ASAP!

wombatee

Here's a way that doesn't even involve the regexp engine:

//I assume you have an array of strings or something...
foreach($strings as $s) {
if (strpos($s,"G9") !== false && strpos($s, "G9,5") === false) {
//it's a match
}
}

Cheers!

Omega Wombat
http://www.drinknation.com

Anon

Well the reason I need a REG EXP to do this is because this is part of a MySQL query.

I have a field that can contain either of those values.

Omega Wombat wrote:

Here's a way that doesn't even involve the regexp engine:

//I assume you have an array of strings or something...
foreach($strings as $s) {
if (strpos($s,"G9") !== false && strpos($s, "G9,5") === false) {
//it's a match
}
}

Cheers!

Omega Wombat
http://www.drinknation.com

Anon

Need's PCRE regexps - the ereg functions aren't really up to it:

preg_match("/G9(?!.5)/",$string);

...using a so-called lookahead negative assertion to match "any occurrence of "G9" not followed by a ".5"

Anon

But how would I use this in an SQL query?

Anon

How were you going to use it before?

znouza

eg
select * from table where column regex '/G9[^,]/'

Anon

I tried that but with no success since that expression looks for something that's 3 characters long.

Anon

Then try /G9[^,].*/

How far does MySQL's regexp engine go?

Anon

/G9[^,]*/