MYSQL Select rows where date is older than datetime
I am coding a status item for a website and need to load statuses older than a variable that contains a datetime.
So the database has a field called added date which is a datetime field and I have a string in datetime format and i want to select all rows older than my datetime format string.
How would this be structured in MYSQL?
Thanks in advance.
select status_column from your_table where added_date < '2012-05-12'
mysql DATETIME type is used for values that contain both date and time parts.
SELECT datecolumn FROM table WHERE datetime_date > '2012-05-12 01-32-56'
$today = date('Y-m-d'); SELECT column_name FROM table_name WHERE year(added_date) > $today AND month(added_date) > $today