gturnbul

Find pesky duplicates in mysql

Posted by gturnbul on December 14, 2009 in boring code

Let’s say you had an app that had a ton of users and were suspicious that there were pesky duplicates. Here is a quick mysql select to help put your mind at ease.

select username,count(*) as n
from users
group by username
having n > 1;

or search by first and last name:

select concat(firstname,’ ‘,lastname) as name, [...]

Struggling students take note

Posted by gturnbul on October 7, 2009 in Inspiration

Al started school late due to childhood illness. His mind often wandered and his teacher Alexander Crawford often called him “addled”, which meant “confused or stupid.”. He was kicked out of school three months after starting. He attended three different schools between the ages of seven to nine, and none of his teachers had [...]

fantastic – Bobby McFerrin Hacking the brain

Posted by gturnbul on August 19, 2009 in Entertaining Me is Easy

Hug a developer

Posted by gturnbul on September 12, 2008 in Life Experiences

Probably old news for some.  The little boy made me all weepy, after I code for a few more hours I should go give my kiddos some hugs..  Oh but that meeting is going to throw that off…  jk