I made a mistake to storing date in Mysql Database as a VARCHAR with this format 24-Apr-2018
Now, I need to do searching data(using query) between two dates.
Is there any simple way to convert it into Sqldate format , I ever do changing the format in mysql structure, from VARCHAR into date, but its erasing the values.
The data is more than 10,000 rows, its hard to change it manually.
Any Helps ?