Skip to content

Instantly share code, notes, and snippets.

@esedic

esedic/sameday.sql

Created February 29, 2024 11:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save esedic/6b66a1b0230630b830aa269840769f38 to your computer and use it in GitHub Desktop.
Save esedic/6b66a1b0230630b830aa269840769f38 to your computer and use it in GitHub Desktop.
Download ZIP
Select items/articles that were created on the same day
Raw
sameday.sql
SELECT * FROM mytable WHERE MONTH(created) = MONTH(CURDATE()) AND DAY(created) = DAY(CURDATE()));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment