I have a database in mySQL that I use to keep track of phone calls to my company. I've been able to query the database and get the information I need until now and being pretty much a self taught novice to sql I'm somewaht stumped. What I want to do is to compare specific days of the week in a month to the same month from previous year. An example would be that I would want to compare the 3rd Thursday in May to the 3rd Thursday in May one or even two years ago.
What I have been doing is something like: select * from mytable where dayname(dateint) = 'Thursday' and week(dateint) = "10" However this does not seem to always give me the results I'm expecting. Does anyone have any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
