[luau] SQL Statement help

[Matthew John Darnell]

Aloha,

No need to respond, got an off list respnse.

Aloha.,
Matt
----- Original Message ----- 
From: "Matthew John Darnell" <mdarnell at servpac.com>
To: <luau at videl.ics.hawaii.edu>
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
> LUAU at videl.ics.hawaii.edu
> http://videl.ics.hawaii.edu/mailman/listinfo/luau
>