In MySQL, I am trying to select all rows in which one field's value is equal to another's. How can I do this?
select * from table where field1=field2;
i tried that and it didn't seem to work... might be ie's cacheing behavior
