[luau] SQL Statement help

Matthew John Darnell mdarnell at servpac.com
Sat Aug 16 21:55:00 PDT 2003


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




More information about the LUAU mailing list