regexp madness

[saloon12yrd]

Damn I'm sitting in front of this thing too long...
Here's the problem:
Imagine two SQL queries like these

"INSERT INTO admins
SET id=2, login='test \'user'
"

"UPDATE admins
SET login='saloon12yrd', email='[e-mail]'
WHERE id=1"

Both have a part "SET ...", that's what I'm interested in.
Now what I try to do is preg_match'ing the part in such a way that the "SET ..." is returned in both cases.
I've read the manual several times now but today doesn't seem to be a good day...
I know working regexps for both cases:
case 1: /SET (.)/i
case 2: /SET (.)(WHERE)/i

Can anybody out there tell me how the f... I get both cases done in a single regexp?

thanks a lot,

Dominique

[Anon]

Try:

/SET (.*)(WHERE)?/i

Diego

[saloon12yrd]

No, sorry that's the same as
/SET (.*)/i

Dominique

[Anon]

You could maybe try to match the \n newline and do minimal mathing with the *? like this:

/SET (.*?)\n/i

or try this (again .*? !!)

/SET (.*?)(WHERE)?/i

[saloon12yrd]

Nope, greedyness doesn't seem to be a factor in this. Obviously it IS a factor but the ? doesn't change a bit - either case 1 or case 2 works, never both.

Dominique

[Anon]

Either I don't understand what you want or what, but for me Diego's solution is the right one!!!

$a= "INSERT INTO admins
SET id=2, login='test \'user' " ;
$b= "UPDATE admins
SET login='saloon12yrd', email='[e-mail]'
WHERE id=1" ;
preg_match("/SET (.)(WHERE)?/i",$a,$ma);
preg_match("/SET (.)(WHERE)?/i",$b,$mb);
echo ("$ma[1]<br>");
echo ("$mb[1]<br>");

[saloon12yrd]

I believe both of you pretty much understand what the problem is, the only thing is that the solution doesn't work:

<?
$a = "INSERT INTO admins SET id=2, login='test \'user'";
$b = "UPDATE admins SET login='saloon12yrd', email='[e-mail]' WHERE id=1";
preg_match("/SET (.)(WHERE)?/i",$a,$ma);
preg_match("/SET (.)(WHERE)?/i",$b,$mb);
echo ("$ma[1]<br>");
echo ("$mb[1]<br>");
?>

Output:
id=2, login='test \'user'
login='saloon12yrd', email='[e-mail]' WHERE id=1

I don't want the "WHERE id=1" thing in the second result. If I change the lines 4 and 5 of the code above to:
preg_match("/SET (.)/i",$a,$ma);
preg_match("/SET (.)/i",$b,$mb);
I get the exact same result.

Any further ideas? Thx so far,

Dominique

BTW: I'm using PHP 4.0.6

[[deleted]]

The trick is that the part you're looking for either ends in 'where' or the end of the line:

$a = "INSERT INTO admins SET id=2, login='test 'user'";
$b = "UPDATE admins SET login='saloon12yrd', email='[e-mail]' WHERE id=1";
$sPat = "/SET (.*?)(where|$)/i";
preg_match($sPat, $a, $ma);
preg_match($sPat, $b, $mb);

[Anon]

I don't know.... on my PC the output is following (preg_match("/SET (.*)(WHERE)?/i",$a,$ma)😉:

INSERT INTO admins SET id=2, login='test \'user'
Gives:
id=2, login='test \'user'

UPDATE admins SET login='saloon12yrd', email='[e-mail]' WHERE id=1
Gives:
login='saloon12yrd', email='[e-mail]'

Between the lines, I use PHP 4.06 too....

[saloon12yrd]

That's weird, I get the whole thing... thanks anyways.

Dominique

[saloon12yrd]

Sorry vincent I hate workarounds:

<?
$a = "INSERT INTO admins SET id=2, login='test \'user'";
$b = "UPDATE admins SET login='saloon12yrd', email='[e-mail]' WHERE id=1";
$sPat = "/SET (.*?)(where|$)/i";
preg_match($sPat,$a,$ma);
preg_match($sPat,$b,$mb);
echo ("$ma[1]<br>");
echo ("$mb[1]<br>");
?>

Dominique