How about
SELECT * FROM queLog WHERE accessed = "Y" AND targetApp = "acadreg" AND enteredQue >= '2004-11-09 18:00:00';
(You said greater than first, then you said greater than or equal to. I went with the latter.)
Michael
Kory Wheatley wrote:
I'm trying to do a select statement where:
field "targetApp" equals the value "acadreg" and
field accessed equals the value "Y" and
filed enteredQue is like "2004-11-09 18%" the whole "enterqueue" fieild is something like "2004-11-09 16:00:34"
Here's what I'm trying to accomplish, I want to get all the records that equal Y and equal "acadreg" and the enteredQue is greater than 2004-11-09 18:00:00" which is 6pm.
Here's what I tried:
select * from queLog where accessed = "Y" and targetApp = "acadreg" and enteredQue like "2004-11-09 18%";
It needs to display all the records that are greater than or equal to 6pm on Nov 9 2004 and of course, that equal
equal accessed = "y" and targetApp = "acadreg".
I might have over explained this request, I'm sorry for that.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
