Arg, come on, really.
where t.created = date(now()));
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Mon, April 16, 2007 15:18, Jay Blanchard wrote:
[snip]
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
[/snip]
Argh, that was not the one i wanted to send :)
This is the one:
select s.* from store s
where s.id not in
(select t.storeid from trans t
where t.created date(now()) - interval 1 day);
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Tue, April 17, 2007 09:20,
[snip]
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
[/snip]
This is close, but it does not exclude previous days. I only want to see
those that have not logged in today.
--
MySQL General Mailing List
For list archives:
[snip]
[snip]
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
[/snip]
This is close, but it does not exclude previous days. I only want to see
those that have not logged in today.
[/snip]
select store.storeid, store.stname
from store
Good day gurus and gurettes!
I have a table;
| transactionid | int(11) | NO | PRI | | auto_increment |
| username | varchar(32) | NO | | ||
| storeid | varchar(6) | NO | | ||
| action| int(4) | NO
and store.active = 'yes'
and date(transaction.created)=date(curdate())
group by store.storeid;
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 6:22 PM
To: [EMAIL PROTECTED]
Subject: how to tell if something hasn't happened yet
Good day gurus
How about this:
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Sat, April 14, 2007 00:22, Jay Blanchard wrote:
Good day gurus and gurettes!
I have a table;
|