MySQL check difference in days

I've encountered this problem recently and here's how I figured it out:

SELECT COUNT(*) FROM pvp_kills WHERE death_killer='Camaroow' AND DATEDIFF(CURRENT_TIMESTAMP(), death_time) <= 1;="" <="" pre="">

There is no period at the end of this blog post


Thanks for reading my post! If you enjoyed it or it helped you, please consider liking/tweeting this page, commenting, or following me on GitHub or Twitter!