TRY
select a, b from THE_TABLE where a<>b ;
a and b are the column A and culumn B respectively.
>From: "Matthew John Darnell" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: [luau] SQL Statement help
>Date: Sat, 16 Aug 2003 21:59:32 -1000
>
>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
STOP MORE SPAM with
the new MSN 8 and get 2 months FREE*
