Skip to content

Instantly share code, notes, and snippets.

@j03k64
j03k64 / happy-birthday-scott.sql
Created September 15, 2015 20:28
Happy Birthday, Scott!
SELECT CONCAT("Happy Birthday, ", TRIM(C.FirstName), ' ', TRIM(C.LastName), '!!!')
FROM Contact C
WHERE C.Birthdate IS NOT NULL
AND LENGTH(TRIM(C.FirstName)) > 1
AND LENGTH(TRIM(C.LastName)) > 1
AND CONCAT(YEAR(CURDATE()), '-', DATE_FORMAT(C.Birthdate, '%m-%d')) = CURDATE();