mysql where clause in not return empty?

Question

Hello This is my table.

table name is location

id      location
1       location1
2       location2
3       location3
4       location2
5       location4
6       location3

the below are query.

SELECT * FROM location WHERE `location` IN ('location2,location1')

it return empty value i need output to all location1 and location2 records in table

i need output is

1    location1
2    location2
4    location2

thank you.

Kurt Du Bois · Accepted Answer · 2014-09-26 11:59:13Z

2

SELECT * FROM location WHERE `location` IN ('location2' ,'location1') LIMIT 20

Your error was in the quotes containing the possible values.

answered Sep 26, 2014 at 11:59

Kurt Du Bois

7,6654 gold badges27 silver badges33 bronze badges

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

1 Answer 1