I'm trying to do some type of conditional select statement and I have no
idea how.
What I would like is something like this (using pseudo sql)
select (if(col1>1) true else if (col1<= 1) false) from foo;
does that make sense? Basically I want one column of my result set to be
true or false based on some logic. I can do it in code and have my program
handle it, but I was hoping to do it in SQL.
Thanks,
Matt O'Connor
