MYSQL How to use trim in select query

my table have set of records around 50,

in the table i have column called USERNAME, but some of username leading and trailing have the white space ,

so am not getting exact order result because of white space,

So tell me how to use the trim in SELECT query ,

Thanks