Need help: Date format

Question

I have birth date data stored in Mysql table as below:

id firstname middlename lastname   birth
---------------------------------------------
 1 Harry     Chandra    Sihombing  1999-12-14
 2 Janice    Mona       Sihombing  2010-04-20
 .  ...      ...        ...        ...

How can I create a search function to collect data from the table and restrict the output to rows "where age > 25" (and/or other function using ">" (greater) "=" (equal).

Answer 1

maybe something like this with DATE_SUB

SELECT * FROM people WHERE DATE_SUB(NOW(),INTERVAL 25 YEAR) > birth

in php:

$age = (int)$_POST['age'];
$sql = "SELECT * FROM people WHERE DATE_SUB(NOW(),INTERVAL $age YEAR) > birth";

Answer 2

Here's a hint:

SELECT NOW(),
    DATE(NOW()),
    DATE_SUB(NOW(), INTERVAL 25 YEAR),
    DATE(DATE_SUB(NOW(), INTERVAL 25 YEAR))