Re: Date comparisons

2006-07-14 Thread Philip Hallstrom
I've found something that works (in MySQL 5, anyway), but I don't know whether it's accepted practice. If I want to find all records with a date in, say, March 2006, it works if I use "datefield like '2006-03%'" because it's a string. This seems kind of obvious and a lot tidier than doing "da

Date comparisons

2006-07-14 Thread Chris Sansom
I've found something that works (in MySQL 5, anyway), but I don't know whether it's accepted practice. If I want to find all records with a date in, say, March 2006, it works if I use "datefield like '2006-03%'" because it's a string. This seems kind of obvious and a lot tidier than doing "da