Selecting multiple values from 2 columns in MySQL

Question

I'm trying to select multiple values from 2 columns. I can get the query working with 1 column, eg:

SELECT *
FROM table
WHERE
    town IN ( 'Oxford' , 'Abingdon' )

However, I want to do something like:

SELECT *
FROM table
WHERE
    town IN ( 'Oxford' , 'Abingdon' )
AND type IN ( 'type1','type2')

but I can't get it to work.

Basically I want to select all where:

town=Oxford and type=type1
town=Oxford and type=type2
town=Abingdon and type=type1
town=Abingdon and type=type2

Second query looks good to me... unless I am totally missing something. — Zoidberg
– Zoidberg, Commented Aug 26, 2010 at 10:17
your something like query look that is good , did you try to run it? — Haim Evgi
– Haim Evgi, Commented Aug 26, 2010 at 10:18
"but I can't get it to work." - Do you get an error? Does it return no results? Is the data actually there for the scenarios you mention (i.e. are all Oxford and Abingdon records actually type3 and type 4)? — Fenton
– Fenton, Commented Aug 26, 2010 at 10:27

Piotr Müller · Accepted Answer · 2010-08-26 10:25:42Z

1

Maybe this will work:

  SELECT * FROM table WHERE  (town IN ( 'Oxford' , 'Abingdon' )) AND (type IN ( 'type1','type2'))

answered Aug 26, 2010 at 10:25

Piotr Müller

5,5665 gold badges60 silver badges83 bronze badges

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

1 Comment

dmid Over a year ago

Well, It must be a bad day! I must have had a typo AND was stupid enough not to check the error messages before posting! You're all right - The query I typed into my message works - DOH!

Collectives™ on Stack Overflow

Selecting multiple values from 2 columns in MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related