Mysql query: selecting from two rows in the same field

Question

I have the following mysql table:

Products

ID -- NAME -- INSTOCK -- REFERER -- DISCOUNT 
1 -- pen -- 1 -- google.com -- 50 
2 -- mouse -- 0 -- google.ca -- 30
3 -- keyboard -- 1 -- google.ca -- 30
4 -- screen -- 1 -- yahoo.com -- 50
5 -- mother board -- 1 -- yahoo.ca -- 30
6 -- printer -- 1 -- google.com --30

What I'm trying to get is all the rows that have:

INSTOCK equals 1 and the REFERER equals google.com and google.ca

How can I do this?

Thanks a lot

Just to make sure you want to select products that are in stock and the referrer is either google.com or google.ca? For your example you want 1, 2, 3 and 6 returned? — Belinda
– Belinda, Commented Mar 9, 2011 at 15:30
That seems to be quite impossible. What ID's would you expect to get back from this query? — anothershrubery
– anothershrubery, Commented Mar 9, 2011 at 15:33
The IDs should be 1, 3 and 6. Number 2 has instock= 0. Thanks — ADM
– ADM, Commented Mar 9, 2011 at 15:41

simendsjo · Accepted Answer · 2011-03-09 15:41:21Z

1

I bet you mean OR, not AND in your question:

Your looking for IN:

SELECT * FROm table WHERE INSTOCK = 1 AND REFERER IN ('google.com', 'google.ca')

Or you could use OR:

SELECT * FROM table WHERE INSTOCK = 1 AND (REFERER = 'google.com' OR REFERER = 'google.ca')

answered Mar 9, 2011 at 15:41

simendsjo

4,7693 gold badges29 silver badges55 bronze badges

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

Comments

Álvaro González · Accepted Answer · 2011-03-09 15:41:13Z

0

This is pretty basic SQL:

SELECT ID, NAME
FROM Products
WHERE INSTOCK = 1 AND (REFERER = 'google.com' OR REFERER = 'google.ca');

Further reference:

answered Mar 9, 2011 at 15:41

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Comments

Artusamak · Accepted Answer · 2011-03-09 15:41:17Z

0

Use the WHERE statement combined with AND conditions in your query:

// Example SELECT ID, NAME FROM table WHERE INSTOCK = 1 AND (REFERER = 'google.com' OR REFERER = 'google.ca');

edited Mar 9, 2011 at 15:41

answered Mar 9, 2011 at 15:34

Artusamak

2,51019 silver badges20 bronze badges

3 Comments

ADM Over a year ago

thanks Artusamak but with your query I get 0 results, and that's not true :(

Belinda Over a year ago

What is your expected result?

Álvaro González Over a year ago

@user523129 Read your question again. That's what you asked for ;-)

Collectives™ on Stack Overflow

Mysql query: selecting from two rows in the same field

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related