PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table tbl (id int primary key auto_increment, name varchar(64), gender char(1), dob date); insert into tbl (name, gender, dob) values ('Bob', 'M', '1991-05-12'), ('John', 'M', '1993-01-01'), ('Aloce', 'F', '1994-06-01');
Copy Clear
Copy Format Clear
<?php $query = "SELECT tbl.* FROM tbl JOIN tbl AS tmp ON tbl.dob BETWEEN DATE_SUB(tmp.dob, INTERVAL 2 YEAR) AND DATE_ADD(tmp.dob, INTERVAL 3 YEAR) AND tmp.id = :id WHERE tbl.id <> :id"; $stmt = $pdo->prepare($query); $stmt->execute([':id'=>2]); $res = $stmt->fetchAll(PDO::FETCH_ASSOC); var_export($res);
Show:  
Copy Clear