Get data from table from list of rows in MySQL

Question

How can I query data from a table available in a list of rows?

I only want to get data from a list of strings.

Example:
Table
ID Name
1  Big
2  Small
3  Extra
4  Orange
5  Drink

List of Strings:
Big
Small
Extra

Thanks!

+2

steamboy Apr 27. 10 at 19:33

2 answers

SELECT * FROM theTable WHERE column_name IN ('Big', 'Small', 'Extra')

+2

egrunin Apr 27. 10 at 19:35

Matthew jones · Accepted Answer · 2010-04-27T19:35:19+0000

I assume you want the MySQL IN clause :

SELECT ID, Name FROM TableName WHERE Name IN ('Big','Small','Extra')