hello i have one table with one column called "added "and type "datetime"
for example in one sign the added row has the value "2008-01-25 12:30:20"
i want in mysql query load only by date like mysql_query(select * from signs where added = '2008-01-25'")or die();
but because the row has and the time stamp dont load these value ...
any idea to select well ?
select with date only for datetime row
Moderator: General Moderators
Re: select with date only for datetime row
Code: Select all
SELECT * FROM TABLE WHERE date(added)='2008-01-01'Re: select with date only for datetime row
gery thanks my friend 