How to Treat pulling Data from a field (Wild Cards?)
Posted: Thu Oct 19, 2006 1:38 am
Hi,
In the database the date and time in one field is like this:
I want to run a query based on the date and pay no attention to the time portion.
This does work...
But I only want to search by the dat and I cant figure uot the wild card.
These dont work.
Thank you,
Jason
In the database the date and time in one field is like this:
Code: Select all
2006-09-07 23:20:27Code: Select all
$query = "SELECT * FROM Tickets WHERE LastUpdatedBy='$tech' AND Queue='$client' AND LastUpdated='$date'";Code: Select all
$date = '2006-09-07 23:20:27';These dont work.
Code: Select all
$date = '2006-09-07%';
$date = '2006-09-07*';Thank you,
Jason