title: MYSQL How to use trim in select query
body: <p>my table have set of records around 50, </p>
  
  <p>in the table i have column called <code>USERNAME</code>, but some of username leading and trailing have the white space , </p>
  
  <p>so am not getting exact order result because of white space, </p>
  
  <p>So tell me how to use the trim in <code>SELECT</code> query ,</p>
  
  <p>Thanks </p>