I have created a sql statement that enables me to select all entries in
to MySQL that are dated today, I am trying to do the same for all items
that are now one day old and also two days old etc
I am doing this:
SELECT *
FROM table
WHERE category = 3 AND show = 1 AND date = NOW()-1
I
From: Matthew Stuart [mailto:[EMAIL PROTECTED]
I have created a sql statement that enables me to select all
entries in to MySQL that are dated today, I am trying to do
the same for all items that are now one day old and also two
days old etc
I am doing this:
SELECT *
FROM table
I have created a sql statement that enables me to select all entries in
to MySQL that are dated today, I am trying to do the same for all items
that are now one day old and also two days old etc
I am doing this:
SELECT *
FROM table
WHERE category = 3 AND show = 1 AND date = NOW()-1
I have it
Using a select statement, how does one
select all records that have a date one day
less than the current date? Searching the archives
and I can't seem to find the answer..
Our database has these fields:
EMAIL, AMOUNT, ID, DATE
The date is in format 00/00/
Thanks
--
Bruce Therrien
Bruce Therrien wrote:
Using a select statement, how does one
select all records that have a date one day
less than the current date?
Our database has these fields:
EMAIL, AMOUNT, ID, DATE
The date is in format 00/00/
Gack. I'm guessing 00/00/ is a string?
1) DATE is a MySQL reserved
At 11:02 -0400 9/27/03, Bruce Therrien wrote:
Using a select statement, how does one
select all records that have a date one day
less than the current date? Searching the archives
and I can't seem to find the answer..
Our database has these fields:
EMAIL, AMOUNT, ID, DATE
The date is in