[thelist] date selection and mysql and PHP

Jay Blanchard jay.blanchard at niicommunications.com
Mon May 9 13:45:21 CDT 2005

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?

SELECT * FROM `my_table` WHERE `date_time` LIKE "20050509%"

More information about the thelist mailing list