[thelist] date selection and mysql and PHP
Jay Blanchard
jay.blanchard at niicommunications.com
Mon May 9 13:45:21 CDT 2005
[snip]
Maybe my question is why can't I just say where date row = <my date>
where I try and match just the first part of the date with the first
part of any dates in the table
SELECT * FROM `my_table` WHERE `date_time` = "20050509"
but this doesnt seam to work...
Any ideas? or am I doing it right?
[/snip]
SELECT * FROM `my_table` WHERE `date_time` LIKE "20050509%"
More information about the thelist
mailing list