Noob-ish SQL (MySQL) Query Question?

Yes, eskwayrd is right, unless you just wanted to be extremely stubborn as I often am and do a slew of ( mid(1,2,field)='/G') + mid(2,2,field)='/G' + etc... ) AS g_count