mysql哪里有条件问题

Question

is that possible to use WHERE like this;

$no = $_GET['no'];
$query = "SELECT * FROM `numbers` WHERE `myno` - $no = 4";
...

if not, how can i get the rows like the below example ?

EDIT: to be more clear,

$today = date("Y-m-d");
 $query = "SELECT * FROM `dates` WHERE date - $today = 7";

i want to find rows that has date field which is 7 days ago

thx

Answer 1

If the field is a date field

$query = "SELECT * FROM `numbers` WHERE `myno` = DATE_SUB(`myno`, INTERVAL 7 DAY)"

Edit: or I would prefere this

$query = "SELECT * FROM `numbers` WHERE DATEDIFF(NOW(), `myno`) = 7"

Take a look at the date functions