I did try it, and it doesn't work, I was looking for Ideas that will work.
Looks to me like it should work. Try this and see what you get:
SELECT Column_Count, Column_TotalCount, Column_Count > ColumnTotalCount FROM mytable;
That'll show you what's in the columns, as well as the result of the comparison. Might be instructive.
> Hello,> Perhaps you ought to try it before posting? ;)
Friday, April 16, 2004, 12:50:21 AM, you wrote:
M> Is it possible to use a query to select all rows from the table M> where Column_Count is greater than Column_TotalCount? M> Like this:
M> SELECT * FROM mytable WHERE Column_Count > Column_TotalCount;
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
