MySQL：无法正确比较字符串值作为日期

I am trying to display rows that fall between two ranges. Those two ranges will be dates. One of the column stores the date as a String in the format of "8-10-2017 / 05:00 AM" In order to compare the values I am using the following query: I am trying to display rows that fall between t