How to select different format of the date in mysql
You'll have to bite the apple. There's no way you can do a proper compare without changing any scripts.

You can spare yourself the trouble to adjust your scripts in the way they are generating the dates, by using STR_TO_DATE() function like this:

UPDATE successlog 
       SET successlog.overtime ='00:00'                
           Where date &gt;= STR_TO_DATE('$from', '%d-%m-%Y') AND 
                 date &lt;= STR_TO_DATE('$to', '%d-%m-%Y')


but you have to adjust your scripts somehow. Store your dates with the proper datatype in your database!


Read more about str_to_date() here.