Here's what I have.
SELECT
CASE WHEN
DATE_FORMAT(a.lastLogin, 'W') = DATE_FORMAT(NOW(), 'W')
THEN 'Today'
ELSE
DATE_FORMAT(a.lastLogin, 'W')
END AS lastlogin
FROM authors a
I am pretty sure there is a much simpler way to do this that I'm missing.