title: SQL ignore parenthesis in name field for ORDER BY
body: <p>I would like rows returned in a MySQL query to be sorted alphabetically by surname for which I have an SQL query like:</p>
  <pre><code>SELECT 
    id, 
    substring_index(name, ' ', -1) as surname
  FROM
    my_table
  ORDER BY 
    surname asc
  </code></pre>
  <p>However, <em>some</em> names have parenthesis to denote some special circumstance such as: <code>Laura Angel (retired)</code></p>
  <p>How can I modify my SQL above to ignore the parenthesised text, to sort by surname alphabetically?</p>