title: is it possible to change the collation of one column in a select statement?
body: <p>so i need to change the collation of ONE column from latin1_spanish to latin1_swedish, I found the convert function but can't see how to convert it. </p>
  
  <p>let's say it's column "a"</p>