mysql> SELECT  id, email, str_to_date(concat(birthmonth,"/",birthday,"/",birthyear), '%m/%d/%Y') AS birthdate FROM users WHERE birthyear != 0 HAVING birthdate < str_to_date('00/00/1990','%m/%d/%Y');
+----+---------------------+------------+
| id | email               | birthdate  |
+----+---------------------+------------+
|  1 | [email protected]  | 1983-05-17 |
| 12 | [email protected]               | 1980-03-03 |
| 16 | [email protected] | 1988-04-06 |
+----+---------------------+------------+
3 rows in set (0.00 sec)