I have a table where one of the columns is a view counter and therefore change at every request.
If I select all columns but the view counter will my query still be able to take advantage of the query cache (other columns won't change) ?
Nope. Take a look here:
http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html
The summary of that page for what you are looking for is:
If a table changes, all cached queries that use the table become invalid and are removed from the cache
But, you could create a different table to store your view counter and you would solve the problem. Not sure how complicated that would be, but it is the only option I can see if you want to use the cache.
