Can you execute multiple SELECT statements on a MySQL DB?

Question

How do I execute a query like this using PHP:

 SELECT [name] FROM [items] WHERE [ID]=1, [ID]=2, [ID]=3

and have MySQL return me all 3 rows?

 ID    name
 --    ----
 1     John
 2     Jane
 3     Jack

Answer 1

Use:

SELECT name
  FROM ITEMS 
 WHERE id IN (1, 2, 3)

Answer 2

$result = mysql_query("SELECT name FROM items WHERE id IN (1, 2, 3)");

while($row = mysql_fetch_array($result)) {
  echo $row['name'];
  echo "<br />";
}

Answer 3

select [id], [name] from [items] where [id] in (1,2,3) order by [id]