select * from hymns where firstline matches "G*" order by firstline

Sprague284bC.M.Give me the wings of faith, to riseJ. Smith
Jefferson428, 7Glorious things of thee are spoken
Greenfield121L.P.M.God is our refuge in distress
Salutation1437, 6, 8, 7, 7, 6, 7, 6Good morning, brother pilgrim
Ninety-Third Psalm7S.M.Grace! 'tis a charming soundChapin
Ballstown162L.M.Great God, attend while Zion sings