MYSQL TIMESTAMP comparison

If you are sure about backticks and single quotes and still it doesnt work then try this out,

UPDATE `Table`SET Status=1
WHERE Name='personname' AND 
Time < STR_TO_DATE('2012-12-23 18:00:00','YYYY-MM-DD HH:MI:SS')

You're comparing the string literal 'Time':

'Time'<'2012-12-23 18:00:00'

Try comparing the time column instead:

Time < '2012-12-23 18:00:00'

Or if you have to, surround it in backticks:

`Time` < '2012-12-23 18:00:00'

Live example at SQL Fiddle.

Related