title: How to change the structure of a name field in mysql
body: <p>I have the following problem.</p>
  
  <p>My table, say tab1, has <strong>name</strong> column as follows "LastName, FirstName". I want to make it so that the column becomes "FirstName LastName".</p>
  
  <p>Any ideas on how this is to be done? Note that there is no comma present, but i guess that can be easily removed once I figure out how to actually flip the first and the last names.</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>Thanks.</p>