MySQL datatype conversion from varchar to float

How might I convert a varchar into a float in MySQL while executing a query?