How to use an operator more with a date?

Question

I don’t know what is going on here. Here is the request, directly from phpMyAdmin:

SELECT * FROM `la_schedule` WHERE 'start_date' >'2012-11-18'; 

But I consistently get all the records in the returned table, including those that are listed with the start date 2012-11-01. What gives?

Answer 1

You enlosed start_date with single quotes, forcing it to become a string, use backtick instead

 SELECT * FROM 'la_schedule' WHERE 'start_date' > '2012-11-18'; 

• SQLFiddle Demo

Answer 2

In your application, you are comparing a string called start_date with time.

If start_date is a column, it should be

 SELECT * FROM `la_schedule` WHERE start_date >'2012-11-18';
SELECT * FROM `la_schedule` WHERE start_date >'2012-11-18'; 

(without apostrophe) or

 SELECT * FROM `la_schedule` WHERE `start_date` >'2012-11-18';
SELECT * FROM `la_schedule` WHERE `start_date` >'2012-11-18'; 

(with backticks).



Hope this helps.

Answer 3

Try it.

 SELECT * FROM la_schedule WHERE `start_date` > '2012-11-18'; 

Answer 4

In my case, my column was a date and continued to give me all the entries. What I did to enable time, see the example below

 SELECT * FROM my_table where created_at > '2011-01-01 01:01:01'