I have a column named 'date' in MySQL which have different values of different dates as a string.
2016-09-29 02:19 AM
2016-09-29 02:09 AM
2016-09-29 02:07 AM
2016-09-29 01:51 AM
2016-09-29 01:52 AM
I think the best solution is convert the table field to a date..
Anyway. If you want to use string as date and want to do that query try this:
select * from tblName where cast(date as datetime) > '2016-09-29 01:52'