mysql if in where clause

Question

This is probably very easy and just I'm being thick - I'm trying to stop reserved items from being picked up in the records but only if the stock is greater than 0, I can't work out how to do an unless

"....WHERE blah blah AND (reserved = 0 OR reserved < ".(time()-1200).")"

So the column I'm looking at is called the "stock" column and if that value is 0 then I DO want to display the result

So I thought I could do

if(stock<>0,reserved = 0 OR reserved < ".(time()-1200.")

But that errors...

it's an item that has been timestamped by another user as being in their basket for purchase, I give them 20 minutes to buy it in the meantime I don't want to display those in the shop — user1083382
– user1083382, Commented Apr 17, 2012 at 8:04

Marc B · Accepted Answer · 2012-04-16 15:37:14Z

1

you can't do assignments like that in an if() clause. The format is

if (condition, true_value, false_value)

Possibly something like this will do:

if (stock <> 0, 0, time()-1200) AS reserved

answered Apr 16, 2012 at 15:37

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1083382 Over a year ago

doesn't that go in the SELECT part though? I need it to be in the WHERE clause

Jim · Accepted Answer · 2012-04-16 15:41:15Z

0

I may have misunderstood but wont:

"WHERE blah blah AND (stock = 0 OR reserved = 0 OR reserved < ".(time()-1200).")))"

do what you need?

answered Apr 16, 2012 at 15:41

Jim

22.7k6 gold badges55 silver badges81 bronze badges

Collectives™ on Stack Overflow

mysql if in where clause

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related