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
