Aloha, No need to respond, got an off list respnse.
Aloha., Matt ----- Original Message ----- From: "Matthew John Darnell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 16, 2003 9:59 PM Subject: [luau] SQL Statement help > Aloha, > > I have a mysql database and I need to know when a row has different values > in two fields. The values are either 0 or 1. > > i.e. > Column A Column B > 1 1 > 0 1 > 1 0 > 0 0 > > I would like to know about record 2 and 3. After that I will find out where > the value "1" is. > > Anyone know a SQL statement for something like that? > > I have tried to get all the values in two different hashes but I can't > compare them. Even if I could (I'm sure you can) it would be nice to do it > in one step. > > -Matt > > _______________________________________________ > LUAU mailing list > [EMAIL PROTECTED] > http://videl.ics.hawaii.edu/mailman/listinfo/luau >
