{
  "$type": "site.standard.document",
  "canonicalUrl": "https://rickymoorhouse.uk/blog/2011/2011-06-07-sort-by-surname",
  "path": "/blog/2011/2011-06-07-sort-by-surname",
  "publishedAt": "2011-06-07T13:36:24.000Z",
  "site": "at://did:plc:r53zv4vpzeihop3aliwyejlu/site.standard.publication/3mos5q3a7jf2w",
  "textContent": "ORDER BY SUBSTRING_INDEX(full_name, ' ', -1)",
  "title": "Sort by Surname"
}