query

Populating the Regions, Divisions and States MySQL Tables

The relationships between states, divisions and regions are simple but need to be setup properly from the start. Here we’ll walk though the setup.

Read the full article →

Birthday MySQL Query Hates Timestamps

In order to query the users with birthdays from my MySQL table I had to convert Unix timestamps saved as integers to a more usable DATETIME format, then we explore two ways to query the birthdays.

Read the full article →