title: MYSQL sort words in field
body: <p><strong>Edit 1</strong> the code is just an example, I do not have suburb data, my real data is inherited and messy and could be fixed by creating code out of the database or creating reference data.  The question should have been something like does anyone have a good cell sort function or other solution that can be reused? </p>
  
  <p>Table</p>
  
  <pre><code>CREATE TABLE postcode (
  `id` int NOT NULL AUTO_INCREMENT,
  `suburbs` varchar(2000) DEFAULT NULL,
    PRIMARY KEY (`id`)
  )  ENGINE = InnoDB
  DEFAULT CHARACTER SET = utf8
  COLLATE = utf8_unicode_ci;
  </code></pre>
  
  <p>Insert</p>
  
  <pre><code>INSERT INTO  postcode (`suburbs`)
  VALUES ( 'Zackville;Astor;Mary-town;Jackson' );
  </code></pre>
  
  <p>Want field to be sorted an result to be</p>
  
  <blockquote>
    <p>Astor;Jackson;Mary-town;Zackville</p>
  </blockquote>