Because the Police's "Mother" probably wouldn't sound so good on your Mother's Day mix CD, I first posted a list of songs for mom last year. It's time to drag it out again (and update it a bit)...
Here's a list of songs for mothers or songs about mothers, in no particular order. I've avoided lullabies (songs by moms, typically), as well as songs about general parentual units, or songs about moms and dads. (If you're looking for songs about moms and moms, might I recommend AudraRox's excellent "Moms & Dads," which, song title notwithstanding, is about all sorts of families.)
If a song isn't on the list, it's because of one of the three "O"s: Oversight (I knew about the song and just forgot), Omission (I knew about the song and chose to exclude it), or Obtuseness (I didn't know about the song at all). I expect the third category to be fairly large, so feel free to add your suggestions in the comments section.
"Mama Don't Allow" -- numerous versions; try Brady Rymer's version off of Every Day Is a Birthday
"Mama Hug" -- Brady Rymer, Every Day Is a Birthday
"Mama Is Sad" -- Justin Roberts, Yellow Bus (it's a song about divorce, so I'm guessing it's not gonna go on too many mix tapes)
"Five Little Ducks" -- try version on the Old Town School of Folk Music's Songs For Wiggleworms
"Thank You Mommy" -- The RTTs, Turn It Up Mommy!
"The Coffee Song" -- Ralph's World, At the Bottom of the Sea (not really about moms specifically, but it was the first song that came to my wife's mind when I mentioned the topic of the post)
"Hush Little Baby" -- try version on the Old Town School of Folk Music's Wiggleworms Love You, though it's just as often that Dad is the person buying baby that billy goat
"Mother and I" -- Bill Thomas (and a Circle of Friends), Time Can Be So Magic
"Hope My Mama Says YES!" -- AudraRox, I Can Do It By Myself (more about the kid than the mom, but that's what Mother's Day sometimes ends up being, no?)
"Mommy She Loves Me" -- Ginger Hendrix, Macaroni Boy Eats at Chez Shooby Doo
"Nerves" -- Terri Hendrix, Celebrate the Difference (not really celebratory, but the recipient mom will nod her head in understanding, then ask you to get her a beer)
"A Dozen Roses" and "I Made It For You" -- Peter Himmelman, both off My Green Kite