MYSQL Where IF statement?

Question

Hello I want to select all the entrees in a MYSQL database if a certain value in a row - another value is greater than a certain number. I want something like this but that actually works, is it possible?

$str = date("d/m/y");
$donetime = strtotime($str);

$currentname = mysql_query("SELECT * FROM `entree` WHERE IF(`Uploaded`-$donetime <= 604800)  ");

Is it possible to have something like this? Thanks for your help.

I think what you're looking for is here: http://stackoverflow.com/questions/8444570/using-an-if-statement-in-a-mysql-select-query — Mueyiwa Moses Ikomi, Nov 12 '16 at 18:48

score 0 · Accepted Answer · answered Nov 12 '16 at 18:55

0

If you want to SELECT all rows WHERE Uploaded-$donetime <= 604800 then you should write the following.

SELECT * 
FROM `entree` 
WHERE `Uploaded`-$donetime <= 604800

You might want to read up on SQL.

answered Nov 12 '16 at 18:55

Martin

448
4
12

MYSQL Where IF statement?

1 Answers1