Skip to content

Instantly share code, notes, and snippets.

@IgnoredAmbience

IgnoredAmbience/gist:582491

Created September 16, 2010 14:16
Show Gist options
  • Save IgnoredAmbience/582491 to your computer and use it in GitHub Desktop.
Save IgnoredAmbience/582491 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select ringer_performances.credit, concat_ws(' ',ringers.first_name, ringers.middle_names, ringers.last_name) as name from ringer_performances, ringers where ringers.id = ringer_performances.ringer_id and ascii(ringers.middle_names) != 0 having credit != name;
+-------------------------+-----------------------+
| credit | name |
+-------------------------+-----------------------+
| Nicholas W. Jones | Nicholas W Jones |
| Mark A. S. Jones | Mark A S Jones |
| Peter J. Bennett | Peter J Bennett |
| Andrew J. Graham | Andrew J Graham |
| Richard S. J. Saddleton | Richard S J Saddleton |
| James R. S. Sawle | James R S Sawle |
| Katherine L. Town | Katherine L Town |
| Michael J. Trimm | Michael J Trimm |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Terry M. Astill | Terry M Astill |
| William H. J. Norton | William H J Norton |
| Alison R. Clarke | Alison R Clarke |
| James R. S. Sawle | James R S Sawle |
| Andrew P. F. Bradford | Andrew P F Bradford |
| Rebecca S. Bruce | Rebecca S Bruce |
| Andrew J. Graham | Andrew J Graham |
| Mark C. Bennett | Mark C Bennett |
| Gregory Watson | Gregory J Watson |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Paul CL Bradford | Paul C L Bradford |
| Quentin SA Jackson | Quentin S A Jackson |
| David HW Ottley | David H W Ottley |
| Jon Waters | Jon A Waters |
| James RS Sawle | James R S Sawle |
| Edward Webb | Edward J Webb |
| Andrew PF Bradford | Andrew P F Bradford |
| Garry Barr | Garry S Barr |
| Roger Bailey | Roger D Bailey |
| David HW Ottley | David H W Ottley |
| Quentin SA Jackson | Quentin S A Jackson |
| Andrew PF Bradford | Andrew P F Bradford |
| Roger Bailey | Roger D Bailey |
| Andrew PF Bradford | Andrew P F Bradford |
| John PW Taylor | John P W Taylor |
| Jon Waters | Jon A Waters |
| David HW Ottley | David H W Ottley |
| John PW Taylor | John P W Taylor |
| Andrew PF Bradford | Andrew P F Bradford |
| Quentin SA Jackson | Quentin S A Jackson |
| David HW Ottley | David H W Ottley |
| Paul CL Bradford | Paul C L Bradford |
| Quentin SA Jackson | Quentin S A Jackson |
| Andrew PF Bradford | Andrew P F Bradford |
| John PW Taylor | John P W Taylor |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Quentin SA Jackson | Quentin S A Jackson |
| Andrew PF Bradford | Andrew P F Bradford |
| David HW Ottley | David H W Ottley |
| Quentin SA Jackson | Quentin S A Jackson |
| Kelly Barnes | Kelly N Barnes |
| Jon Waters | Jon A Waters |
| Garry Barr | Garry S Barr |
| David HW Ottley | David H W Ottley |
| Gregory Watson | Gregory J Watson |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Quentin SA Jackson | Quentin S A Jackson |
| Martin Cansdale | Martin J Cansdale |
| Richard PG Hayhoe | Richard P G Hayhoe |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Charles Herriott | Charles W G Herriott |
| Rupert Littlewood | Rupert H J Littlewood |
| Lucy Bricheno | Lucy M Bricheno |
| Garry Barr | Garry S Barr |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Clare E. F. Dyer | Clare E F Dyer |
| Rebecca L. Sugden | Rebecca L Sugden |
| Charles W. G. Herriott | Charles W G Herriott |
| Katherine L. Town | Katherine L Town |
| Jennifer A. Holden | Jennifer A Holden |
| Andrew P. F. Bradford | Andrew P F Bradford |
| David H. Stone | David H Stone |
| Martin J. Cansdale | Martin J Cansdale |
| Andrew P. Sparling | Andrew P Sparling |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Kristine Fowler | Kristine K Fowler |
| Sebastian Lucas | Sebastian B Lucas |
| Andrew Sparling | Andrew P Sparling |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Clara Westlake | Clara P Westlake |
| Helen Mansfield | Helen J Mansfield |
| Peter Jasper | Peter M Jasper |
| Richard Hayhoe | Richard P G Hayhoe |
| Nicholas Jones | Nicholas W Jones |
| Roger Bailey | Roger D Bailey |
| James Eggleston | James K Eggleston |
| Samantha Hovey | Samantha J Hovey |
| Jason Hughes | Jason W Hughes |
| Roger Bailey | Roger D Bailey |
| Samantha Hovey | Samantha J Hovey |
| James Eggleston | James K Eggleston |
| James Eggleston | James K Eggleston |
| Roger Bailey | Roger D Bailey |
| Jason Hughes | Jason W Hughes |
| Ed Webb | Ed J Webb |
| Jason Hughes | Jason W Hughes |
| Charles WG Herriott | Charles W G Herriott |
| Andrew RC Kelso | Andrew R C Kelso |
| Philip RJ Barnes | Philip R J Barnes |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Sebastian Lucas | Sebastian B Lucas |
| David Ottley | David H W Ottley |
| Alison Elwess | Alison E Elwess |
| Peter Blight | Peter J Blight |
| Andrew PF Bradford | Andrew P F Bradford |
| John PW Taylor | John P W Taylor |
| Charles WG Herriott | Charles W G Herriott |
| Andrew RC Kelso | Andrew R C Kelso |
| Charles WG Herriott | Charles W G Herriott |
| Andrew PF Bradford | Andrew P F Bradford |
| Roger Bailey | Roger D Bailey |
| Charles WG Herriott | Charles W G Herriott |
| Andrew PF Bradford | Andrew P F Bradford |
| Andrew RC Kelso | Andrew R C Kelso |
| Charles WG Herriott | Charles W G Herriott |
| Charles WG Herriott | Charles W G Herriott |
| Roger Bailey | Roger D Bailey |
| Charles WG Herriott | Charles W G Herriott |
| Clara Westlake | Clara P Westlake |
| Andrew PF Bradford | Andrew P F Bradford |
| Charles WG Herriott | Charles W G Herriott |
| Charles WG Herriott | Charles W G Herriott |
| Adrian Udal | Adrian R Udal |
| Charles WG Herriott | Charles W G Herriott |
| Andrew PF Bradford | Andrew P F Bradford |
| Andrew PF Bradford | Andrew P F Bradford |
| Charles WG Herriott | Charles W G Herriott |
| Quentin S A Jackson | Quentin S A Jackson |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Jennifer A Holden | Jennifer A Holden |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| William Dawson | William J Dawson |
| Jon Waters | Jon A Waters |
| Rupert HJ Littlewood | Rupert H J Littlewood |
| Andrew PF Bradford | Andrew P F Bradford |
| Clare EF Dyer | Clare E F Dyer |
| Charles WG Herriott | Charles W G Herriott |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Rona Joiner | Rona M Joiner |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Heather Forster | Heather M Forster |
| Sean Langton | Sean D Langton |
| Jon Waters | Jon A Waters |
| Jon Waters | Jon A Waters |
| Rachel Town | Rachel S Town |
| Jon Waters | Jon A Waters |
| Elizabeth LJ Stokoe | Elizabeth L J Stokoe |
| Clare EF Dyer | Clare E F Dyer |
| Andrew PF Bradford | Andrew P F Bradford |
| Rupert Littlewood | Rupert H J Littlewood |
| Charles W G Herriott | Charles W Herriott |
| Charles W G Herriott | Charles W Herriott |
| Roger Bailey | Roger D Bailey |
| Charles W G Herriott | Charles W Herriott |
| Tessa Beadman | Tessa K Beadman |
| Heather Forster | Heather M Forster |
| Clare Dyer | Clare E F Dyer |
| Ian Fielding | Ian R Fielding |
| Elizabeth Stokoe | Elizabeth L J Stokoe |
| Jenny Holden | Jenny A Holden |
| Rupert Littlewood | Rupert H J Littlewood |
| Nicholas Hartley | Nicholas W Hartley |
| Andrew Bradford | Andrew P F Bradford |
| Charles Herriott | Charles W Herriott |
| Oliver Cross | Oliver 8 Cross |
| Katie Town | Katie L Town |
| Nicholas Hartley | Nicholas W Hartley |
| Quentin Jackson | Quentin S A Jackson |
| Heather Forster | Heather M Forster |
| Clare Dyer | Clare E F Dyer |
| Tessa Beadman | Tessa K Beadman |
| Martin Cansdale | Martin J Cansdale |
| Jon Waters | Jon A Waters |
| Andrew Bradford | Andrew P F Bradford |
| Charles W G Herriott | Charles W Herriott |
| Annelise Felton | Annelise O Felton |
| Charles W G Herriott | Charles W Herriott |
| Charles W G Herriott | Charles W Herriott |
| Roger Bailey | Roger D Bailey |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Charles W G Herriott | Charles W Herriott |
| Roger Bailey | Roger D Bailey |
| Charles W G Herriott | Charles W Herriott |
| Charles W G Herriott | Charles W Herriott |
| Charles W G Herriott | Charles W Herriott |
| Jon Waters | Jon A Waters |
| Roger Bailey | Roger D Bailey |
| Annelise Felton | Annelise O Felton |
| Ian Fielding | Ian R Fielding |
| Clare Dyer | Clare E F Dyer |
| Hugh Wilkinson | Hugh J W Wilkinson |
| David Maynard | David G Maynard |
| Heather Forster | Heather M Forster |
| Charles Herriott | Charles W Herriott |
| Andrew Graham | Andrew J Graham |
| Quentin SA Jackson | Quentin S A Jackson |
| Charles W G Herriott | Charles W Herriott |
| Guy Atchison | Guy W Atchison |
| Clara Westlake | Clara P Westlake |
| Peter Jasper | Peter M Jasper |
| Charles W G Herriott | Charles W Herriott |
| Andrew Bradford | Andrew P F Bradford |
| Jenny Holden | Jenny A Holden |
| James Egglestone | James K Egglestone |
| Jon Waters | Jon A Waters |
| Clare Dyer | Clare E F Dyer |
| Rachel Aland | Rachel C Aland |
| Alan Bain | Alan F R Bain |
| Charles W G Herriott | Charles W Herriott |
| Roger Bailey | Roger D Bailey |
| Charles W G Herriott | Charles W Herriott |
| Clara Westlake | Clara P Westlake |
| Guy Atchison | Guy W Atchison |
| Peter Jasper | Peter M Jasper |
| Helen Richardson | Helen E Richardson |
| Hellen Richardson | Hellen V Richardson |
| Nicholas Hartley | Nicholas W Hartley |
| Peter Jasper | Peter M Jasper |
| Andrew Hills | Andrew M Hills |
| Roger Bailey | Roger D Bailey |
| Charles W G Herriott | Charles W Herriott |
| Roger Bailey | Roger D Bailey |
| Charles W G Herriott | Charles W Herriott |
| Charles W G Herriott | Charles W Herriott |
| Roger Bailey | Roger D Bailey |
| Guy Atchison | Guy W Atchison |
| Peter Jasper | Peter M Jasper |
| Elizabeth Stokoe | Elizabeth L J Stokoe |
| Clara Westlake | Clara P Westlake |
| Jon Waters | Jon A Waters |
| Thomas Baldwin | Thomas D Baldwin |
| Peter Jasper | Peter M Jasper |
| Roger Bailey | Roger D Bailey |
| Elizabeth Stokoe | Elizabeth L J Stokoe |
| Andrew Hills | Andrew M Hills |
| Peter Jasper | Peter M Jasper |
| Quentin SA Jackson | Quentin S A Jackson |
| Quentin SA Jackson | Quentin S A Jackson |
| Peter Jasper | Peter M Jasper |
| Roger Bailey | Roger D Bailey |
| Roger Bailey | Roger D Bailey |
| Hugh Spalding | Hugh J Spalding |
| Guy Atchison | Guy W Atchison |
| Peter Jasper | Peter M Jasper |
| Roger Bailey | Roger D Bailey |
| Guy Atchison | Guy W Atchison |
| Peter Jasper | Peter M Jasper |
| Rachel Aland | Rachel C Aland |
| Charles W G Herriott | Charles W Herriott |
+-------------------------+-----------------------+
291 rows in set (0.02 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment