Mysql: Date as string

Question

I have a field in MySQL as varchar and need to do a select with a range. The date is in the following format "%m/%d/%Y" (Ej. 10/14/2010).

Answer 1

Use str_to_date

SELECT STR_TO_DATE(dateColumnName,'%m/%d/%Y');