Mysql date year and month information
<pre><code>SELECT user_guid, test_name, subcategory_name
FROM complete_tests
WHERE YEAR(created_at) ='2014' AND MONTH (created_at) = '10' LIMIT 100;
</code></pre>

<p>When coding with mySQL and using WHERE for the date info, is the "created_at" specific to the tables i am working with or will i always use (created_at)?</p>