Related Posts

Common MySQL Queries

I ran across this terrific resource, Common MySQL Queries.

Tons of great examples…for example:

Given a birthdate in @dob, here are two simple formulae for age in years:

Date_format( From_Days( To_Days(Curdate()) - To_Days(@dob) ), '%Y' ) + 0
Year(Curdate()) - Year(@dob) - ( Right(Curdate(),5) < Right(@dob,5) )

and here is one for age in years to two decimal places, ignoring day of month:

Round((((Year(now()) - Year(@dob)))*12 + (((Month(now()) - Month(@dob)))))/12, 2)

Enjoy!

Read More
"Candy Apple Red (Jane Kelly Mystery)" by Nancy Bush

"Candy Apple Red (Jane Kelly Mystery)" by Nancy Bush

alter-text

If you enjoy light, easy mystery books, then this book is for you. Jane Kelly followed a boyfriend from California to Washington state. She stayed; he didn’t. She studied criminology because he was, and now she’s using that in serving eviction notices. But things get complicated when her ex-boyfriend shows up. And eventually the body of a man who has been missing for four years. There’s our mystery.

Read More