A bit of a warning, if the fields are DATETIME rather than DATE, add the
appropriate hours:minutes:seconds to the test
WHERE datetimefield >'1999-02-01 23:59:59'. When comparing DATETIME fields
with date strings '00:00:00' is assumed and that can cause problems if one
forgets that.
> Have you consi
Sorry. This should have gone back to the list.
-- Mensaje reenviado --
Subject: Re: MySQL 4.0 and concat
Date: Lun 11 Oct 2004 11:37
From: Alfredo Cole <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
El Lun 11 Oct 2004 08:35, escribió:
> Have you considered NOT comparing
Have you considered NOT comparing dates as strings but rather as date
values? That will avoid the use of CONCAT() completely.
SELECT *
FROM sampletable
WHERE datefield >= '1999-01-12' and datefield <'1999-02-01'
This example query will get all of the records from sampletable that were
entere
Hi:
I have a problem in that all statements that include concat execute very
slowly. For instance, if I have three fields in string format that represent
a year, month and day, and want to issue a select like:
select * from cxcmanpag where contact
(year,month,day)<=stringYear+stringMonth+stri
