sql - How do I change precision of float values in mysql? -

hello in database have column numbers such 6.251543423 want make them 6.25 without rounding them.

i've tried update examresults set point = substring(point,0,5) returned values 0

if don't want round must truncate:

truncate(6.251543423,2) 

when cast decimal(n,2) or float(n,2) result rounded.