[thelist] date selection and mysql and PHP

[Jay Blanchard]

[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%"