You can read more about the effect of these operators here:
http://www.googleguide.com/advanced_ope ... rence.htmlBasically all they serve for is narrowing down your competition to sites more relevant to your keyowrd. When you update competition without any advanced parameters you get the number of all results for the keyword in the selected search engine. Pages that mention the keyword once in some insignificant part, like a comment, will also be contributing to how big the number is.
However, when you gather only the pages that have the keyword in their title tag, or in the actual URL, then you are looking at the competition number that shows pages that are really relevant to your keyword and/or optimized for the keyword. So the numbers in your Competition column represent the competition that is really relevant to your site/keyword.