CodeSOD: Simple SQL

SELECT * FROM bean_overtime_availability
 WHERE `startDateTime` >= DATE(NOW()) AND `available` = 1;

One project that John inherited was a fairly simple web application that tracked overtime. Simple, that is, from the front end. The back end PHP code was responsible for querying a MySQL database with queries similar to this:

via CodeSOD: Simple SQL:

Truly wonderful code generator on this one. Made my morning 😉