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. -- Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 ######################################### Everything must point to him.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
