Re: count of a certain value in two columns

[Jay Pipes]

Player 123 got X assists from 124:

SET @playerid = 123; // Some player ID
SET @assistplayerid = 124; // Some player ID

SELECT COUNT(*)
FROM scorelist
WHERE player = @playerid
AND (
OR a1 = @assistplayerid
OR a2 = @assistplayerid
);

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com